Nedd Suggestion

[#1]

Hi All,

When extract from csv file , I find the date format like 20,151,101 .How can I correct this format to like 20151101 or 01/11/2015.

Thanks,

Manoj.

[sunny_talwar]

May be this:

Date(Date#(Num(DateField, '##'), 'YYYYMMDD'), 'DD/MM/YYYY') as DateField