How to read a timestamp from a csv file

[#1]

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]

Try this:

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

- Marcus

[vardhancse]

Try to do the format change in csv only.

If not in QV you can mention as

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

[hector_munoz]

Hi Idriss,

Try the following:

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

Regards,

H

[ramasaisaksoft · Accepted solution]

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.

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/DateAndTimeFunctions/d...

[Anonymous]

Hi,

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

Best regards,

Cosmina

[#7]

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

I am using Rama's one.

Thank you again.

[#8]

Hi,

Thank you; yours is also working...

Best regards

Idriss