Get month from dd/mm/yyyy

[daveh]

Hi,

I have a field which stores the date in date/time format dd/mm/yyyy, and I want to build an expression within a query that extracts the month in full text form (e.g. xx/06/xxxx = "June").

I'm pretty sure this must be easy but I can't quite work it out as I haven't got much experience with Access queries.

Thank you for your help in advance.

David.

 

[lupins46]

mymonth:format(mydatefieldnamehere, "mmmm")

 

[daveh]

Thank you, this is great!

Dave.

 

[SJMcAbney]

First of all, you aren't actually storing the date in a format. Dates are stored as 8 byte floating point numbers. You have only chose a format to represent the date when viewing the table directly.

You don't need to use the Format() function in a query either as, if you right click on the field in the Query Grid, you can simply set the Format property of the field to mmmm.

Stewart J. McAbney | Talk History

 

[GOstlund]

You could also use this:
MonthText = MonthName(Month(DATE_FIELD))

Make the code do all the fancy work...

Hope that helps,
Gavin