Skip to main content
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

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

View solution in original post

4 Replies
senpradip007
Specialist III

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

MK_QSL
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

Date( DateField, 'YYYYMDD') as NewDate