
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date time stamp conversion: YYYY/MMDD HH:MM:SS
Hi Everyone,
I'm having trouble with converting a time stamp and can't seem to find the solution to this online.
I'm have a timestamp field in the format of: YYYY/MM/DD HH:MM:SS and I would like to separate the date and time fields from this. I tried several different types of syntax to get the required answer however nothing seems to work. So far the result of trying to convert the date timestamp is Qlikview not loading in the field.
Does anyone know how I can solve this issue?
Thanks,
Isaac
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The below should work if all you need to do is seperate them
=Date(Date#(Left(Date,10), 'YYYY/MM/DD'), 'DD/MM/YYYY')
=Time#(right(Date,8), 'HH:MM:SS')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have an example app / data you could share so we can see how it's been setup?


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My guess is that you are not loading the timestamp values as a correctly formatted datetime so the data is stored in Qlik as a numeric value.
These posts should help.
Once you have the timestamp data in the correct format using time(frac([YourTimeStampField])) and date(floor([YourTimeStampField])) will separate the date and time components

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
try with subfield(datefield,' ',1) as date
subfield(datefield,' ',2) as time
also check timestamp#(),timestamp(),date() and date#() in help menu
syntax and explanation is available in help
Regards,
Prashant
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The below should work if all you need to do is seperate them
=Date(Date#(Left(Date,10), 'YYYY/MM/DD'), 'DD/MM/YYYY')
=Time#(right(Date,8), 'HH:MM:SS')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with:
Date_filed=Date#(left(Timestamp_field,10),'YYYYMMDD')
Time_field=Time#(right(Timestamp_field ,8),'HH:MM:SS')
After, you can format them with Date and Time function.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tried everything and took ages, but this worked perfectly thank you so much

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your help

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your help

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your help
