The day of the Week

[leebo1973]

Hi all

I have a list of dates on which tasks were performed.

I want to be able to see if there is a pattern, i.e. lots done on a Monday

Can I extract the Day from the date, and return a value Monday, Tuesday, Wednesday etc??

Thanks

 

[pr2-eugin]

You can !

? [URL="http://www.techonthenet.com/access/functions/date/weekdayname.php"]WeekdayName[/URL]([URL="http://www.techonthenet.com/access/functions/date/weekday.php"]Weekday[/URL](Date(), vbMonday))
Thursday
? WeekdayName(Weekday(#31/01/2014#, vbMonday))
Friday

 

[namliam]

How about
?Format(date(), "DDD")
Thu
Or if you prefer full names
?Format(date(), "DDDD")
Thursday

 

[pr2-eugin]

Or

How about
?Format(date(), "DDD")
Thu
Or if you prefer full names
?Format(date(), "DDDD")
Thursday

Many roads lead to Rome.