Date to month number?
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).