Last Month end date

[risabhroy_03]

(Qlik Sense)

I have a date field named "ASDT" and multiple dates are stored in this dimension.

I want to pick the last month-end date and store it in a variable.

For example, today's date is 19-10-2021, but the variable should store the date as 30-09-2021.

Please help me.

[risabhroy_03]

Hello, my problem is solved. But when I just run let vLastmonthdate = MonthEnd(MonthStart(now())-1);

why does it shows 30/12/1899?