Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am loading date field YYYY-MM-DD
An example : 2014-02-10
How can I load date field as YYYYMDD ?
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField
Try to use like Date(Date#([Date Field], 'YYYY-MM-DD'), 'YYYYMMDD').
Date(Date#(YourDateField,'YYYY-MM-DD'),'YYYYMMDD') as YourDateField
Hi try this
Date(Date#([Date ],'YYYY-MM-DD'),'YYYYMMDD') as temp_date,
Date( DateField, 'YYYYMDD') as NewDate