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
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
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
3 matches
Mail list logo