Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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)));
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)));
num or rangemax
let vM=rangemax(Month(addmonths(peek('MaxDate', $(m)-1, 'MaxMonth'),1)));
There´s no sense to use Max() in this case, because you have only one value returned by Peek