topic Re: How to truncate timestamp in QlikView

How to truncate timestamp

varunreddy — Mon, 28 Dec 2015 20:57:31 GMT

Hi Guys,

I am looking to truncate time stamp. i.e MM/DD/YYYY hh:mm:ss to MM/DD/YYYY

For example:

8/7/2015 17:00:00 to 8/7/2015

Thanks in advance!

Regards,

Varun

swuehl — Mon, 28 Dec 2015 20:58:43 GMT

Use something like

Date(Floor( TimestampField), 'MM/DD/YYYY') as Date

or if you need to interprete your timestamp

Date(Floor( Timestamp#( TimestampField,'MM/DD/YYYY hh:mm:ss')),'MM/DD/YYYY') as Date

sunny_talwar — Mon, 28 Dec 2015 20:59:12 GMT

Try this:

Date(Date#(Left(TimeStampField, 8), 'M/D/YYYY'), 'MM/DD/YYYY') as Date

varunreddy — Mon, 28 Dec 2015 21:07:10 GMT

Thank You Swuehl.

Regards,

Varun