Dates are duplicating

[BeesKnees]

I have the following expression in qlik script. As soon as I run it, it duplicated records

date(floor(dtFromDate,'dd-MM-yyyy'),'yyyy-MM-dd')) as Date,

this is the date format ,2022-02-11 08:24:00.000000

Please help

[rwunderlich · Accepted solution]

Your floor function is incorrect. It should be:

date(floor(dtFromDate),'yyyy-MM-dd')) as Date,

-Rob