how to change the date format from: 'Jan11', 'Feb11', 'Dec11' etc. to '01.Jan11', '02.Feb11, '12.Dec11'. Please let me know if there is any specific function for this operation. Thanks in Advance.
You can globally set the DateFormat with the variable in the script header.
Or using Date() function with an appropriate format code, maybe like
Set DateFormat ='DD.MMMYY';
or
LOAD
..
Date(DateField,'DD.MMMYY') as YourNewDateFormat,
..
From TableWithDateField;
DateField must have a recognized date type before your could re-format it with Date() function. If it's just a string, you need first to apply Date#() function. But, since your strings don't contain a Day, I don't know how you want to parse it in, do you keep a Day field separately?
