Re: Getting first day of week (as date) from week() function?

2007-05-09 Thread Andrew Scott
Would this work for you? #DateFormat(DateAdd("d", "-#DayOfWeek(Now()) - 1#", Now()), ", d, ")# On 5/10/07, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > I'm building an app where I am keeping track of sales on a weekly basis, > so > I am storing the number of the week (as a tin

Re: Getting first day of week (as date) from week() function?

2007-05-09 Thread Teddy R. Payne
Something like this may help you: #dowStr# day of week #woy# #yr# Your could easily make the cfswitch statement into a UDF called something like DayOfWeekOrder. On 5/9/07, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > > I'm building an app wh

Getting first day of week (as date) from week() function?

2007-05-09 Thread Pete Ruckelshaus
I'm building an app where I am keeping track of sales on a weekly basis, so I am storing the number of the week (as a tinyint) and the year (as a smallint). Now there is a requirement to generate a report where the date of the first day of the week (i.e. 5/13/2007 being the date fo the first day o