I have a date field as 25012007 (january 25 , 2007) so in the text format 'DDMMYYYY'
What is the best way to transform this field in a date format 'YYYY/MM/DD' in the script.
date(date#(DateField, 'DDMMYYYY'), 'YYYY/MM/DD')
Tx Michael for your help
Tx Hector for your help - LOL
Hi, you can use
date(date#(DATE_FIELD,'DDMMYYYY'),'YYYY/MM/DD') as field_YYYYMMDD
this is going to transform the original in a field with the format YYYYMMDD, but internally it's going to be a date, so you can use year(), month() etc..
2 minutes of difference xD
Retrieving data ...