topic Re: Convert Timestamp to Date in QlikView

Convert Timestamp to Date

Wed, 12 Feb 2014 07:53:13 GMT

Hello Community,

I have a Timestamp date For example (2012-03-29 11:35:24.6270000 +00:00), I need to get the Date from this i.e 2012-03-29.

Please find the sample file.

I want it using Date functions only.

Note: I tried below expressions, but dint work.

date(floor(CompleteWorkflowDate))

Thanks,

Angad

Sokkorn — Wed, 12 Feb 2014 07:58:56 GMT

Hi Angad,

How about this one =Left(CompleteWorkflowDate,10)

Regards,

Sokkorn

Sokkorn — Wed, 12 Feb 2014 08:01:53 GMT

Or try with this long function

=Date(Floor(Date#(CompleteWorkflowDate,'YYYY-MM-DD hh:mm:ss.fffffff +ff:ff')))

Regards,

Sokkorn

Wed, 12 Feb 2014 08:06:28 GMT

BINGO!

Thanks a lot Sokkorn. I was not aware about those extra fffff's .

Thanks,

Angad

Thu, 06 Mar 2014 17:47:57 GMT

I found this answer very helpful in solving my own problem.

I had a CSV file loaded and needed to convert it's many timestamp fields into a date.

Here is my slightly different code:

Date(floor(NUM(Timestamp#([FIELD NAME], 'DDMMMYYYY:hh:mm:ss')))) AS [NEW FIELD NAME],

Thanks,

Paul

Fri, 07 Mar 2014 06:18:29 GMT

Thanks for sharing Paul. I am happy that it was helpful to you as well

Thanks,

Angad