Making Master Calender

[alkesh_sharma]

Hello,

I have a data in which the date format is as below:

1-JAN_2013

2-JAN_2013 and so on...

How can i change it in standard format as the Year(), Month() commands are not working on the mentioned format.

Thanx in Advance

[er_mohit]

try this

load*,

year(Date) as Year,

Month(Date) as Month;

load

Date(Date#(Purgechar(Datefield,'_,-'),'DDMMMYYYY'),'DD-MMM-YYYY') as Date

FieldA,Fieldb,

....

..so on

from table;