Date function issue in qliksense

Aspiring_Developer — Mon, 07 Jun 2021 13:40:47 GMT

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 ?

Re: Date function issue in qliksense

Or — Mon, 07 Jun 2021 14:07:07 GMT

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.