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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please help..Need a report due within 7 Weekdays 3
Iif statement that sees the formmatted date value on query table 3
Set weekday 2
Reports and Date Increments 2
Very Weird Date Format Problem 3
Previous Month/week Criteria answer here 3
OnFormat Event for Calendar Detail Duane Hookom 2
Automatically Shifting Report. 2

Back
Top