month(now())***RESOLVED***

VB Code:

Label2 = Month(Now())

i am using this to label my calendar for the current month, and i realize this returns a numeric. is there a way for it to return text like june instead of 6.


thanks in advance annie

Label2 = Format$(Month(Now()), "mmmm")

ok it works, but it brought up January
shouldnt it bring up August
???

Label2.Caption = Format(Now, "MMMM")

i got it!!!!! thanks so much

Yes, that's correct. That's what happens when I give an answer without trying it first. :)

:) :) :) thanks again