
Anonymous
Not applicable
2017-10-24
09:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
String to date Qliksense
I am new to Qliksense. I have a field in this format YYYYMMDD000000 I want to convert to date YYYY / MM / DD how can i do?
I tried thid function date (FieldName, 'YYYYMMDD000000') it did not work
thank you for helping me
Regards,
6,644 Views
6 Replies

MVP
2017-10-24
11:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be try this
Date(Date#(Left(FieldName, 8), 'YYYYMMDD'), 'YYYY/MM/DD') as DateField
6,402 Views

Anonymous
Not applicable
2017-10-24
11:36 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
thanks!
I put Date(Date#(dt_enreg_cmde,'YYYYMMDDhhmmss'),'DD/MM/YYYY hh:mm:ss') 🙂
6,402 Views

MVP
2017-10-24
11:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I thought you only needed Date part of the string... anyways I am glad you were able to figure it out

MVP
2017-10-24
11:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is your original date format.
6,402 Views

Anonymous
Not applicable
2017-10-24
12:17 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks all!
it's ok.
6,402 Views

Contributor III
2017-10-24
12:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi.. please try this
=Date(Date#([Field Name], 'YYYYMMDD000000'),'MM/DD/YYYY')
6,401 Views
