Date format

[#1]

Hi,

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.

Regards

JJ

[Anonymous]

=

date(date#(DateField, 'DDMMYYYY'), 'YYYY/MM/DD')

[hector]

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..

rgds.

[hector]

LOL

2 minutes of difference xD

[#5]

Tx Michael for your help

[#6]

Tx Hector for your help - LOL