Bad format of Month saved in variable

[janturon]

Hi,

I need help with variable.

I have Field Month with values in format like this:

Month

01

02

03

I have defined variable:

vmaxmonth=Max(Month)

But result of vmaxmonth in set analysis or text object is not 03, but 3.

[kaushiknsolanki · Accepted solution]

Hi,

This depends on what data format you have in Month field.

If it is a Text then you should use the Maxstring instead of Max function.

If it is a numeric value you should use num(Max(Month),'00')

Regards,

Kaushik Solanki

[janturon]

This is right: num(Max(Month),'00')

Where can I see format of Fields?

[kaushiknsolanki]

The Easy option is, add the filter on sheet and observe the data, if it is on left side it is text else it is number.

Regards,

Kaushik Solanki