AnsweredAssumed Answered

Date to month number?

Question asked by Jonna on Jan 22, 2012
Latest reply on Jan 22, 2012 by Jonna

Title

Date to month number?

Post

I have 2 fields; a date field (StartDay), and another field with a function Month(StartDay), which is supposed to return a number representing the month. No matter what the date is, the number returned is always "1".

What is wrong?

In the Help it reads: "Month(“3/19/2010”) returns 3. This example assumes that the operating system date format is set to MM/DD/YYYY."

Must I have my operating system date format is set to MM/DD/YYYY? It's now DD/MM/YYYY (European).

 

Thanks

Outcomes