Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be this:
Date(Date#(Num(DateField, '##'), 'YYYYMMDD'), 'DD/MM/YYYY') as DateField