Date question (1 Viewer)

[arage]

Date question
I have this function giving me the date on my report control:
=Month(Date())
the control has a format property of “mmmm” but that gives me January, if I remove the “mmmm” I see a value of 2 (which is correct) so why does “mmmm” reset 2 to January rather than February? Please advise.

 

[dlgates]

Problem is that you should not use the month function at all. Either

=Format(Date(),"mmmm")
or
=Format(Now(),"mmmm")

will produce what you want.