Conversion date from YYYY-MM-DD to YYYYMMDD

[Anonymous]

I am loading date field YYYY-MM-DD

An example : 2014-02-10

How can I load date field as YYYYMDD ?

[senpradip007]

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

[MK_QSL · Accepted solution]

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

[#4]

Hi try this

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

[tyagishaila]

Date( DateField, 'YYYYMDD') as NewDate