Question regarding Month() Function

jduenyas — Tue, 09 Apr 2013 18:58:34 GMT

Hi all

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.

Example:
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())?

Thanks

Re: Question regarding Month() Function

Tue, 09 Apr 2013 20:15:50 GMT

Write your formula like the following:

=num(month(now()))

This will return the numerical version of the month.

Stan

jduenyas — Tue, 09 Apr 2013 20:54:48 GMT

Thanks.

That did the trick!