Breaking down the date to days of the week

[joe31709]

In one field I have the date (AUG 20, 2003) and in the next field I would like it to say Wed. How do I go about that.

Thanks

 

[pdx_man]

Format(YourField,"ddd")

 

[joe31709]

Thank you

ddd worked for me


Joe

 

[Rich]

Why would you want to do this in a query?

 

[namliam]

Probably a st*p*d (sorry) user request....

 

[Rich]

 

[pdx_man]

I have dozens of queries that I have to export to Excel several times a month for different clients. I have requests like this, too. They require the data laid out just so.

 

[joe31709]

people ask if they can have it a certain way and i am like um yes lol

 

[Rich]

I have dozens of queries that I have to export to Excel several times a month for different clients. I have requests like this, too. They require the data laid out just so.

Yes, that would be the only logical reason though, surely?