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

[#1]

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

[sunny_talwar]

Try this:

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

[#3]

That looks like it has worked. Thank you!

[#4]

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

Date(Floor( TimeStampField ))

[Colin-Albert]

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