Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Try this:
date(floor(timestamp#(20160816121046, 'YYYYMMDDhhmmss')), 'DD/MM/YYYY')
- Marcus
Try to do the format change in csv only.
If not in QV you can mention as
Date(TimestampField,'DD/MM/YYYY')
Hi Idriss,
Try the following:
Date(Timestamp#(date_hour_field, 'YYYYMMDDhhmmss'), 'DD/MM/YYYY')
Regards,
H
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.
Hi,
Try, date(date#(left(DATA,8),'YYYYMMDD'),'DD/MM/YYYY')
Best regards,
Cosmina
Thanks a lot for all the prompt support; most solutions are working.
I am using Rama's one.
Thank you again.
Hi,
Thank you; yours is also working...
Best regards
Idriss