M
Mark Carlyle via AccessMonster.com
How can I convert a number date to a word day?
I want to give 7/18/2005 and get back Monday
I want to give 7/18/2005 and get back Monday
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
make a date a weekday (like 7/18/05 = Monday)
R
Ron Weiner
Mark
You can use the format function.
Format(#7/18/2005#,"dddd")
Ron W
You can use the format function.
Format(#7/18/2005#,"dddd")
Ron W
R
Rick Brandt
Mark said:How can I convert a number date to a word day?
I want to give 7/18/2005 and get back Monday
Format([FieldName], "dddd")
or
Format(#7/18/2005#, "dddd")
M
Mark Carlyle via AccessMonster.com
Thanks a ton!
Rick said:How can I convert a number date to a word day?
I want to give 7/18/2005 and get back Monday
Format([FieldName], "dddd")
or
Format(#7/18/2005#, "dddd")