datepart help

[barlee]

I have written a statement to display the month only from a date, but I want the month to display the literal, not the number. In other words, I want the date to display as Oct 2008, not 10 2008. Here is what I have that displays 10/2008, can someone fix my statement so it displays Oct 2008, please?

=(DatePart('m',[ActionDate])) & " " & Year(Date())

 

[gemma-the-husky]

something like

format(month(actiondate),"mmm") & " " & year(actiondate)

maybe just

format(actiondate,"mmm yy")

 

[naungsai]

Month: format([ActionDate],"mmm yyyy")

 

[barlee]

ok, thanks, naungsai. that worked!

in another query, I want to find records that have a date older than three years from the first of the current month. am I going to use datepart in this query as well?

don't know why I have such a brain block on this date stuff, but I appreciate all the help.

 

[raskew]

I want to find records that have a date older than three years from the first of the current month.

Try:

<DateSerial(Year(Date())-3, Month(Date()), 1)

HTH - Bob

 

[barlee]

Awesome! Thanks, raskew!