Date is incorrect

[chellebell1689]

So I have to text boxes, one for month and one for year. Below is the control source for each box. When I go into Report View, I get January 1905....This is definitely NOT January 1905....I've checked the date on my clock, it says today's date... Can anyone tell me what's wrong?

=Format(Month(Now()),"mmmm")
=Format(Year(Now()),"yyyy")

 

[JLCantara]

What you get is the initial internal date: January 1905. Using Month and Year in this context is an error. Instead use:
Format(Now(),"mmmm")
Format(Now(),"yyyy")
and it will work...
JLC

 

[jdraw]

Try
=format(Now(),"mmmm")
=format(Now(),"yyyy")

 

[chellebell1689]

Thanks! That works perfectly!! XD

 

[JLCantara]

Hey JDraw, your copying my replies????
We posted at the same time!!!!!
JLC