monthnumber

[smilingjohn]

PLease find the atachment of the QW file ..

Epertise please do suggest

Thanks in advance

[tresB · Accepted solution]

Why don't you use the LDDate in the expression instead like:

=num(month(max(LDDate)))

[antoniotiman]

Try to change

SET DateFormat='DD-MM-YYYY';

to

SET DateFormat='MM-DD-YYYY';

in Script.

[prat1507]

Why are you using Created date?

Please use this =num(month(max(LDDate)))