Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert Date to Text


Hi All,

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

Regards

Sharath

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
gautik92
Specialist III
Specialist III

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

  ];