Convert Date to Text

[#1]

Hi All,

How to Convert 7/29/2015 into 29-Jul-2015.

Regards

Sharath

[jonathandienst]

=Date(Date#('7/29/2015', 'M/DD/YYYY'), 'DD-MMM-YYYY')

[gautik92]

Month1:

MAPPING

  LOAD * inline

  [

  MonthNo,MonthCharacter

  1,Jan

  2,Feb

  3,Mar

  4,Apr

  5,May

  6,Jun

  7,Jul

  8,Aug

  9,Sep

  10,Oct

  11,Nov

  12,Dec

  ];