topic Getting rid of Time in Timestamp in QlikView

Getting rid of Time in Timestamp

Thu, 17 Jun 2010 17:45:55 GMT

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?

Getting rid of Time in Timestamp

Thu, 17 Jun 2010 18:40:49 GMT

How about you use like this?

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

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

Getting rid of Time in Timestamp

Thu, 17 Jun 2010 18:51:17 GMT

Try this

date(floor(num(field)))

Getting rid of Time in Timestamp

johnw — Thu, 17 Jun 2010 22:35:27 GMT

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.