topic Re: Timestamp removal from Date in QlikView

Timestamp removal from Date

Anonymous — Tue, 18 Jul 2017 12:34:56 GMT

Hi All

I have been trying to remove Timestamp from Date field with following syntax

Date(OVESCO_ADD_DATE, 'MM/DD/YYYY') As OVESCO_ADD_DATE,
DATE(FLOOR(Timestamp#(OVESCO_ADD_DATE)),'MM/DD/YYYY') As OVESCO_ADD_DATE,
Date(Floor(TimeStamp#(OVESCO_ADD_DATE))) As OVESCO_ADD_DATE,
Date(TimeStamp#(OVESCO_ADD_DATE,'MM/DD/YYYY HH:MM:SS'),'MM/DD/YYYY') As OVESCO_ADD_DATE,
Date(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS'),'MM/DD/YYYY') as OVESCO_ADD_DATE,

Result is either blank column or duplicate values(MM/DD/YYYY format) in List box.

All I want is this date value in MM/DD/YYYY format

Thanks

Satish

Re: Timestamp removal from Date

tresB — Tue, 18 Jul 2017 12:38:30 GMT

Use floor() like:

Date(floor(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS')),'MM/DD/YYYY') as OVESCO_ADD_DATE,

Re: Timestamp removal from Date

sunny_talwar — Tue, 18 Jul 2017 12:40:18 GMT

You need to add the Floor function here

Date(Floor(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS')),'MM/DD/YYYY') as OVESCO_ADD_DATE,

or use DayName() function

DayName(Date#(OVESCO_ADD_DATE,'DD/MON/YYYY HH:MM:SS')) as OVESCO_ADD_DATE,

Re: Timestamp removal from Date

Anonymous — Tue, 18 Jul 2017 19:53:22 GMT

Hi Sunny/ Tresesco

I appreciate your reply.

But with both suggestion this date is still blank(null)

Re: Timestamp removal from Date

sunny_talwar — Tue, 18 Jul 2017 19:58:17 GMT

Try this

Date(Floor(Date#(OVESCO_ADD_DATE,'DD/MMM/YYYY HH:mm:SS')),'MM/DD/YYYY') as OVESCO_ADD_DATE,

Re: Timestamp removal from Date

Anonymous — Wed, 19 Jul 2017 13:34:21 GMT

Hi Sunny/ Tresesco

Still issue as blank column.

Thanks

Re: Timestamp removal from Date

sunny_talwar — Wed, 19 Jul 2017 13:41:08 GMT

What is the exact format for OVESCO_ADD_DATE?