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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Remove minutes and seconds in the date

Hello everyone ,
I have a problem that concerns the date .
I have a golf date : 07/20/2014 00 : 00.00 . How can I remove the minutes and seconds remaining intact date .
Thank you

10 Replies
sunny_talwar

Yes for removing the timestamp all together you can use

Date(Floor([golf date])) as [golf date]