topic Re: How to read a timestamp from a csv file in QlikView

How to read a timestamp from a csv file

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am new to the Qlikview world.

I have a date field named Timestamp to import into Qlikview from a CSV file.

The field format is: YYYYMMDDhhmmss (20160816121046 for 16th of August 2016 at 12:10:46).

I would like to have it as a date with format DD/MM/YYYY.

Thanks in advance for helping me.

marcus_sommer — Tue, 21 Feb 2017 10:57:59 GMT

Try this:

date(floor(timestamp#(20160816121046, 'YYYYMMDDhhmmss')), 'DD/MM/YYYY')

- Marcus

vardhancse — Tue, 21 Feb 2017 10:58:14 GMT

Try to do the format change in csv only.

If not in QV you can mention as

Date(TimestampField,'DD/MM/YYYY')

hector_munoz — Tue, 21 Feb 2017 10:58:57 GMT

Hi Idriss,

Try the following:

Date(Timestamp#(date_hour_field, 'YYYYMMDDhhmmss'), 'DD/MM/YYYY')

Regards,

ramasaisaksoft — Tue, 21 Feb 2017 11:07:09 GMT

YYYYMMDDhhmmss (20160816121046 for 16th of August 2016 at 12:10:46).

Date(Date#(FieldName,'YYYYMMDD HH:MM:SS'),'YYYYMMDD HH:MM:SS')

EX:-=Date(Date#('16JAN2014','DDMMMYYY'))

The below link will help to you full understand on Date functions in Qlikview.

Anonymous — Tue, 21 Feb 2017 11:10:17 GMT

Hi,

Try, date(date#(left(DATA,8),'YYYYMMDD'),'DD/MM/YYYY')

Best regards,

Cosmina

Tue, 21 Feb 2017 11:17:56 GMT

Thanks a lot for all the prompt support; most solutions are working.

I am using Rama's one.

Thank you again.

Tue, 21 Feb 2017 13:08:19 GMT

Hi,

Thank you; yours is also working...

Best regards

Idriss