
Anonymous
Not applicable
2015-08-12
04:49 AM
- 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 ?
- Tags:
- new_to_qlikview
4,367 Views
1 Solution
Accepted Solutions

MVP
2015-08-12
04:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField
3,835 Views
4 Replies


Specialist III
2015-08-12
04:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try to use like Date(Date#([Date Field], 'YYYY-MM-DD'), 'YYYYMMDD').
3,835 Views

MVP
2015-08-12
04:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField
3,836 Views

Not applicable
2015-08-12
04:59 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi try this
Date(Date#([Date ],'YYYY-MM-DD'),'YYYYMMDD') as temp_date,
3,835 Views


Specialist
2015-08-12
05:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Date( DateField, 'YYYYMDD') as NewDate
3,835 Views
