Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BeesKnees
Contributor
Contributor

Dates are duplicating

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

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Your floor function is incorrect. It should be:

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

 

-Rob

View solution in original post

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Your floor function is incorrect. It should be:

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

 

-Rob