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
Solved! Go to 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")
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")
Thank you very much, that worked!