Weekday Trend Report

  • Thread starter Thread starter Jaz
  • Start date Start date
J

Jaz

I need to develop a report that calculates by quarter, weekday trends (which
weekday has the highest usage).

How do you extract the weekday from each date field? I have the long date
format which shows the full date including day of week, just not sure how to
pull out only the Mondays, etc.

Any help is greatly appreciated.
 
Hi Jaz
you can use the function "DatePart"
![Week_day] = DatePart("WW", ![Date], vbFriday)

where
![Week_Day] = the field to contain the weekday name
![date] = your long date field

let me know if you still need assistance
 
Back
Top