topic Re: How to remove time stamp from DATE field value. in QlikView

How to remove time stamp from DATE field value.

qlikviewforum — Wed, 04 May 2016 11:07:33 GMT

I have DATE field with time stamp.I want to get away DATE field with time stamp. I tried that using below but it is not removing the time stamp from DATE field value. Please help!

Date(DATE,'MM/DD/YYYY') as PERIOD

Re: How to remove time stamp from DATE field value.

sunny_talwar — Wed, 04 May 2016 11:08:07 GMT

Use Floor() function

Date(Floor(DATE), 'MM/DD/YYYY') as Period

Re: How to remove time stamp from DATE field value.

PrashantSangle — Wed, 04 May 2016 11:10:49 GMT

Hi,

Date(DateField,'DD/MM/YYYY') work if your dateField in date datatype.

If it is string

then you required Date#() or timestamp#()

Regards

Re: How to remove time stamp from DATE field value.

PradeepReddy — Wed, 04 May 2016 11:11:09 GMT

one more option..

Makedate(Year(Date_Field),Month(Date_Field),Day(Date_Field)) as Date_Field_New

Re: How to remove time stamp from DATE field value.

swuehl — Wed, 04 May 2016 11:13:08 GMT

Or DayName() if your default date format is 'MM/DD/YYYY':

DayName( DATE) as PERIOD

Re: How to remove time stamp from DATE field value.

qlikviewforum — Wed, 04 May 2016 11:18:33 GMT

Tried that but it didn't worked. I was surprised too.

Re: How to remove time stamp from DATE field value.

swuehl — Wed, 04 May 2016 11:20:03 GMT

Make sure your timestamps are interpreted as such

Why don’t my dates work?

For example, use as default timestamp format code that matches the input format.

Re: How to remove time stamp from DATE field value.

sunny_talwar — Wed, 04 May 2016 11:26:06 GMT

Is your date correctly read by QlikView? If not then as Max mentioned you might need to use Date#() or TimeStamp#() functions. A good way to check if they are read correctly or not is to create a straight table with DateField as Dimension and Num(DateField) as Expression. If you see numbers against each date, it is read correctly. If not, then you have to use Date#() or TimeStamp#()

Re: How to remove time stamp from DATE field value.

qlikviewforum — Wed, 04 May 2016 12:18:25 GMT

Thanks Sunny it is working now not sure what was the issue earlier.