=Max(Year) not working

[bhavvibudagam]

Hi Experts,

Can any one please help me on below issue.

From my date field when i tried to find max(Year) i am getting 2.02k instead of 2018.

Please help me on this. Same issue for Month and Monthname as well max(Month) or Max(Monthname) is also not working.

[Anil_Babu_Samineni]

You may change your number format from custom to auto.

[bhavvibudagam]

Hi Anil,

Thanks for your reply. Its working fine in Charts under measures.

But in text object I have to show max(Year)&''&Max(Month) there i am getting the issue.

[sudhirpkuwar]

Try

Year(Max(Date))

[Shiva123]

can u attach  the file ? may be there is something issue with your date field

[honeyasha]

You can use =max(Year) in text object  to get single row input .

[qlikviewwizard]

Hi,

My guess is Date filed is like text.

Try like this.

=Max(Year(Date(Date#(Date,'DD/MM/YYYY'))))

Raed this article.

Why don’t my dates work?

[Anil_Babu_Samineni]

Still i am not seen any error your measure? Can you post screenshot