G
Guest
Can you please advise what the formula would be to convert the week number
into the date of the first day of that week? For example:
This is week 45. The first day was Sunday, and first date of week 45 is
Nov-4-2007.
I am writing a qury to produce daily, weekly and monthly sales totals. I
know part of this can be filtered in Report Writer, but would like to see the
data displayed in the query as well.
Thanks!
into the date of the first day of that week? For example:
This is week 45. The first day was Sunday, and first date of week 45 is
Nov-4-2007.
I am writing a qury to produce daily, weekly and monthly sales totals. I
know part of this can be filtered in Report Writer, but would like to see the
data displayed in the query as well.
Thanks!