Return the Month name from a datetime field

[Guest_imported]

how can I use a query to return the month name from a datetime field.

Ex: SELECT Month(date) FROM tbl

Can you do this in access SQL??

Thanks

 

[ShaneBrennan]

Hi Grasshopp2k

You need to use for Format function in your query. It is an extremely powerful function to display time, dates, numbers, etc in an infinate variety.

Try the following expression on the query design screen:

Format$(Month([DOB]),"mmmm&quot

replace DOB with the date/time field you want to change.

Hope this helps

Shane

Shane Brennan
Shane.Brennan@tcat.ac.uk