topic Re: Time conversion in QlikView

Time conversion

praveenkumar_s — Wed, 25 Nov 2020 16:16:04 GMT

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...

Re: Time conversion

asgardd2 — Tue, 20 Dec 2016 07:26:41 GMT

Hello!

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

Re: Time conversion

Tue, 20 Dec 2016 07:30:43 GMT

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

Re: Time conversion

avinashelite — Tue, 20 Dec 2016 07:32:27 GMT

if you want only the date try like this

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

Re: Time conversion

surendraj — Tue, 20 Dec 2016 09:03:09 GMT

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

Re: Time conversion

ishanbhatt — Tue, 20 Dec 2016 10:50:06 GMT

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