Day of the Week

[scott_hanebutt]

How do I determine the day of the week from a date? I wanting to write code
that will check a date field (which allways contains today's date) and bassed
on what day of the week it is (Monday, Tuesday...) I will have something
happen.

Is there some other simpler way to tell what day today is?

Thanks,
Scott Hanebutt

 

[Dale Howard [MVP]]

Scott --

Have you tried the Weekday(date) function? The function returns a whole
number representing the day of the week, where Sunday =1. Hope this helps.

 

[scott_hanebutt]

Thanks, just what I needed.

Scott --

Have you tried the Weekday(date) function? The function returns a whole
number representing the day of the week, where Sunday =1. Hope this helps.