Why does the wrong month show up

[akedm]

Hi,

I'm writing this in April 2024, in case anyone some months later is wondering why I'm getting the results I am.

In VBA, I get this :

MsgBox Now	4/10/2024 11:27:19 AM
MsgBox Year(Now)	2024
MsgBox Month(Now)	4
MsgBox Format(Month(Now),"00")	04
MsgBox Format(Month(Now),"MMMM")	January

Why do I get January? Did Daylight Savings Time hit especially hard in 2024?

[TMS]

Because it should be MsgBox Format(Now, "MMMM")

[TMS]

With formulae:

=NOW() 10/04/2024 21:18
=TEXT(NOW(),"dd") 10
=TEXT(NOW(),"ddd") Wed
=TEXT(NOW(),"dddd") Wednesday
=TEXT(NOW(),"mm") 04
=TEXT(NOW(),"mmm") Apr
=TEXT(NOW(),"mmmm") April
=TEXT(NOW(),"mmmmm") A
=TEXT(NOW(),"y") 24
=TEXT(NOW(),"yy") 24
=TEXT(NOW(),"yyy") 2024
=TEXT(NOW(),"yyyy") 2024
=TEXT(NOW(),"h") 21
=TEXT(NOW(),"hh") 21
=TEXT(NOW(),"m") 4
=TEXT(NOW(),"mm") 04
=TEXT(NOW(),"s") 20
=TEXT(NOW(),"ss") 20
=TEXT(NOW(),"0") 45393

In VBA code, replace TEXT with Format, and NOW() with just Now.

[akedm]

Yeah, yeah - I'm seeing that now. I was playing around with it based on your first answer, and as you were composing your second response. Turns out I was just getting lucky with the other way I was doing it...up to a point.

Thanks .

[TMS]

You're welcome. Thanks for the rep.