Convert Date to Day of the Week

[hikerdood]

Does anyone know how to Convert Date to Day of the Week. I pull down records from a database and import into Access. The file has various Column Headings such as Trans Date, TDMonth TDYear but not TDDAY. I am trying to figure out how to covert the [Trans Date] Column Records into the day of the week in my query. I attempted to use the DateName function in an alias column called Wkdy: but to no avail.

[Trans Date] Wkdy(DateName,"dw"), [Trans Date]))
3/2/2019
3/5/2019



Any ideas.

Regards

Gene

[isladogs]

Various methods including Format(DateField,"ddd") or Format(DateField,"dddd") which give e.g. Fri & Friday respectively

[hikerdood]

Thank you works perfectly. Can you recommend an Access Book that shows all of the Access functions and how they work?

Regards

Gene

[davegri]

that shows all of the Access functions and how they work?

https://www.techonthenet.com/access/functions/index.php

This one is pretty good, with descriptions and examples.

[hikerdood]

Thank you. Great go to.

Regards

Gene