Date to day

[DavyLad]

Hi there. I am trying to calculate the day from a date. I apologise for not knowing the correct function, but have not used Access for some time. Many thanks

David

 

[johndoomed]

strDay= Format(strDate, "dddd") will give you the day.

Check out the function "Weekday" for more advanced calculations.

 

[DavyLad]

Thanks a lot John