
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Conversion date from YYYY-MM-DD to YYYYMMDD
I am loading date field YYYY-MM-DD
An example : 2014-02-10
How can I load date field as YYYYMDD ?
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please dont duplicate the thread..
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Please dont duplicate the thread..
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try:
Table:
LOAD * INLINE [
data
2014-02-10
];
t2:
load
Date(data,'YYYYMDD') AS DATE
Resident Table;
Drop Table;

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMDD') as YourDateField
If you need YYYYMDD (assuming it was not a typo)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It should be a typo as
2015115 could be 15th Jan 2015 or 5th November 2015..

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No I am wrong... ! It will work as YYYYMDD

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I agree
I feel dumb now.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
YYYYMDD will work but YYYYMD will not !
Load
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField1,
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMDD') as YourDateField2,
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMD') as YourDateField3
Inline
[
YourDateField
2015-01-15
2015-11-5
];
YourDateField1 | YourDateField2 | YourDateField3 |
---|---|---|
20150115 | 2015115 | 2015115 |
20151105 | 20151105 | 2015115 |

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Greetings
Thanks for your post in Qlik Community. I have moved your post to the App Development sub community. Based on the content of your post I think it will be visible to more members in the new location.
The Education group is only for questions related to training, certification, and any programs we offer.
Thank you,
Sarah Miller
