Looking for a function that will return the day of the week (M, T, Wetc.) for a given date...

[Coll]

I'm looking to convert a date into the day of the week it occurred on
- hopefully using a simple function. E.g. if the field value is
6/13/08, it would return a value of Friday. Any ideas?

[Mikal via AccessMonster.com]

Re: Looking for a function that will return the day of the week (M, T, Wetc.) for a given date...

Coll wrote:

>I'm looking to convert a date into the day of the week it occurred on
>- hopefully using a simple function. E.g. if the field value is
>6/13/08, it would return a value of Friday. Any ideas?

try FORMAT([MyDateField],'dddd')

Mike

--
Mike Pippins

"We have met the enemy and he is us." -- Pogo Possum

Message posted via AccessMonster.c om

http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200806/1