Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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 ?

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField

View solution in original post

4 Replies
senpradip007
Specialist III
Specialist III

Try to use like Date(Date#([Date Field], 'YYYY-MM-DD'), 'YYYYMMDD').

MK_QSL
MVP
MVP

Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField

Not applicable
Author

Hi try this


Date(Date#([Date ],'YYYY-MM-DD'),'YYYYMMDD') as temp_date,

tyagishaila
Specialist
Specialist

Date( DateField, 'YYYYMDD') as NewDate