Date function issue in qliksense

[Aspiring_Developer]

Hello All,

I am facing a very weird problem. Here is my date field in script:-

Date= {"$(=(Max(Date)))"}  

monthstart(addmonths(max(Date),-12))

Whenever i am using addmonths , it is changing my date format.

I have tried date () also , but still it is giving me same output. How can I manage this ?

Can anyone please help me ?

[Or · Accepted solution]

You should be able to explicitly format the date using Date(YourDate,'MM/DD/YYYY') or Date(YourDate,'DD/MM/YYYY') as appropriate.

If you prefer, check your default app date format (set in the script) and change the format to whichever is appropriate.