Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Date conversion problem - starting with DD-MMM-YYYY hh:mm:ss

Hello,

I want to convert a field I have in Qlik Sense from the following:

DD-MMM-YYYY hh:mm:ss (e.g. it might look like 13-JUN-2015 12:21:33)

I want it to give me just the date without the time.

I've tried using the timestamp function both in the data load editor, and also whilst trying to create a master dimension, but it hasn't worked for me so far.

Can anyone please help?

Thank you

4 Replies

Re: Date conversion problem - starting with DD-MMM-YYYY hh:mm:ss

Try this:

Date(Floor(Date#(YourDateField, 'DD-MMM-YYYY hh:mm:ss'))) as Date

Not applicable

Re: Date conversion problem - starting with DD-MMM-YYYY hh:mm:ss

That looks like it has worked. Thank you!

Not applicable

Re: Date conversion problem - starting with DD-MMM-YYYY hh:mm:ss

Generally Qlikview automatically converts dates or time stamps into number. use the Floor function to truncate the time stamp.

Date(Floor( TimeStampField ))

Re: Date conversion problem - starting with DD-MMM-YYYY hh:mm:ss

This post give a good overview of dates & time fields. Get the Dates Right

Community Browser