How can I change the date fomat of a dimension?

[#1]

I have a Date feild as dimension.

How can I change its format to "DD-MMM-YY". I am getting just an integer right now.

Please Help.

Best Regards,

Gaurav Tyagi

[sreenivas]

Date(FieldName,'DD-MMM-YY')

[#3]

hi

try this

LOAD

     Date,

     Year(Date) AS Year,

     Month(Date) AS Month,

     Day(Date) AS Day

     '

     '

     ';

LOAD

     Date(Date#(DateField, 'DD-MMM-YY')) AS Date

'

'

'

'

FROM ABC.txt; 

[#4 · Accepted solution]

hi

In script change to

date(Datefield,'DD.MM.YYYY') as DateField

[#5]

Thanx Guys