Weekday Trend Report

[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.

 

[Alaa Noor]

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