How to convert date in dd-MM-yy to dd/mm/yyyy

1

Hi,

I am trying to convert this format to a date in EM so that I can load it to a sql table
fomat in input file is like: 25-APR-23 Normally I convert to number, then convert to text and give a format, but EM doesn't recognize it. Any advice?

2

Hi @EasyMorphNewbie,

You can convert that date either with the following expression: date([Date], "dd-MMM-yy") or with the "Conver data type" action with the "Text to Date" mode and the same date format:

image
image596×701 17 KB

3

This worked, thank you...!