Month(today()) returning null value

[#1]

Hi All,

It's NYE, so this is probably a result of the end of the working year, but this is confusing the life out of me.

I have two variables I'm declaring at the beginning of my script:

let vCurrentYear  = year(today());

let vCurrentMonth = month(today());

The first correctly returns 2013.

The second appears to return a null value (to check I put both into separate text objects on my sheet. The vCurrentMonth displays as '-', the vCurrentYear as '2013').

Any ideas?

Thanks!

Rory.

[#2]

Always try and avoid the Now() function since it polls the operating system every second and hence could slow down the system. Use Today() instead.

[#3]

Thank U