Time conversion

[praveenkumar_s]

Hi,

I have a date in excel in the format '2/21/2016 4:00:00 AM' when i load the script i didnt get the correct date format and also i want only the date and removing time from the above foramt. How can it be done? I hope somebody helps...

[asgardd2]

Hello!

date(timestamp#('2/21/2016 4:00:00 AM','M/D/YYYY h:mm:ss tt'))

[#3]

Hi Praveen,

When you load any date fields into qlikview, It will be stored as number internally, You need to convert it into your flexible date format.

You can use this expression

=Date(Field,'DD-MM-YYYY') or You can set format in Number tab as below

--Ashok

[avinashelite]

if you want only the date try like this

date(Floor(field_name) ,'DD-MM-YYYY') as field_name_New

[surendraj]

Hi praveen kumar,

if you want customised date format try this one.

if you want to make your standard format into this DD-MM-YYYY

then try below expression in script:

date(timestamp#('2/21/2016 4:00:00 AM','M/D/YYYY h:mm:ss tt'),'DD-MM-YYYY' ) as new_date

--surendra

[ishanbhatt]

Hi Praveen,

Use below statement in your script.

Date(Floor(Num(Date_Field))) AS Date_Field.

You can use Floor or Ceil as per your requirement.

Ishan