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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Getting rid of Time in Timestamp

Hey,

I'm trying to get rid of the time in a timestamp in the load script, and just have it show the date. I'm aware of functions like date(), but it only seems to change the formatting, not the underlying data. It will still, for example, show the whole DateTime, including "12:00:00 AM", in the Current Selection Box, even though I have a date()-function around my field in the load script. I've also tried the date(floor(field))-combination.

Any ideas?

3 Replies
Not applicable
Author

How about you use like this?

Date(datefield,'M/D/YYYY')

or

Please see image, it in the number presentation of date in the object.





Not applicable
Author

Try this

date(floor(num(field)))

johnw
Champion III
Champion III

Or date(daystart(Timestamp)). Here, daystart() is doing exactly what floor() does, but it's using a date and time function instead of a mathematical function, so it seems more consistent and correct to me. Honestly, I usually use floor(), but I feel like I SHOULD be using daystart() for consistency.