Return number for Month

[stjernvd]

Hi,

This script doesn't work, (MaxDate = 30 Aug 2015):

let vMN=Max(Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1)));

I need vMN to = '9' for September...and it's not returning anything at all.

let vM=Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1)); 

this script returns Sep, so why doesn't the above script work?

[sunny_talwar · Accepted solution]

How are you creating MaxDate??

Max(Date) as MaxDate??

If that is true, try this may be:

LET vMN = Num(Month(AddMonths(Peek('MaxDate'), 1)));

Try this:

LET vMN = Num(Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1)));

[maxgro]

num or rangemax

let vM=rangemax(Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1)));

[Clever_Anjos]

There´s no sense to use Max() in this case, because you have only one value returned by Peek