Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Your floor function is incorrect. It should be:
date(floor(dtFromDate),'yyyy-MM-dd')) as Date,
-Rob
Your floor function is incorrect. It should be:
date(floor(dtFromDate),'yyyy-MM-dd')) as Date,
-Rob