Today() is giving old date

[Beaujon1]

Hi

So I'm trying to get the month name from the date of today like this:
Text(Month(Today());"mmmm")

But it gives me the month January instead of February. If I write it like this:

Text(Month(Today());"[$-nl-NL]dd mmmm yyyy")

I get 01 January 1970. What am I doing wrong?

Thanks in advance

[Pstork1 · Accepted solution]

The Month() function gives the number of the month from the date, but Text() is expecting a full date time.  That's why you are getting the wrong output.  To get the month name for today just use this.

Text(Today(),"mmmm")

[Beaujon1]

Thank you very much, that worked!