in the Help section the description of the Month() function says as follows:
Month. Returns a text string representing the month when the fraction of expr is interpreted as a date, but can be formatted as a number.
month( '1971-10-30' ) returns Oct.
(Worth noting that the functions Year() and Day() return integer and not text)
However, in the Edit Script section, when building a calendar and using the Month() function it returns an integer 1, 2, 3, ...
Why is the difference and how can I get the numerical value of the Month(Today()) or Month(Now())?
Month is a dual function. It returns a String or a Number depends on the data type.
If you use it in a text object, it returns a string, but you can force it to be a number using Num() function.
The post on this thread from Evan Kurowski was accidentally deleted and had been marked as the correct answer. In order to restore points to all participants I have copied, reinserted and remarked as correct. Thanks for your patience!
i want to create a function month(today()) in the set analysis, however that makes reference to months before. for now, i've written this formula in relation a month immediately antecedent:
the problem is when i try to go as behind on the months, because i put for example "-3" and data don't change.
can you help me understand ehat could be the problem?