Displaying dates on a report

[RT]

I am trying to display the current month name in the header of a report. I have managed to get the month number using the Now and Month functions, but I cannot find a way of converting this into the month name. Is this possible or is ther another way round it?

 

[llkhoutx]

Use the Format function on the date.

 

[BukHix]

RT

I needed to do the same thing a while back and I was able to do it like this. This code is behind a command button:

Dim dtDate2 As String
dtDate2 = Format(Date, "mmm")
DoCmd.OpenReport "repEmpUpdates", acViewPreview, , _
    "[Month] = '" & dtDate2 & "'"

See this thread for more information - Topic: Getting the current month with code