Number of Months

[mario-sarkis]

Dear ALL,

How can I right a variable in the script that count the number of Months Year to date

Let say we are in Jan it should be 1 if we are in February it is 2

Please help

thank you

[YoussefBelloum]

Hi,

maybe this:

let vVariable= num(month(today()));

with this, on every reload, the output of your variable will be the month number of day of the reload..

in Jan it will be 1, in May it will 5 etc

[shiveshsingh]

May be this?

=num(Month(today()))

[Anonymous]

Hi,

maybe something like:

let vVariable= num(month(<Date>)) - num(month(today()));

The above is for example if perhaps your financial year starts in any other month than Jan

[suren946]

Hi Mario,

Did you got the answer, if yes post the resolution which might help others else post some sample data here so that community can help you