Skip to main content
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Showing results for 
Search instead for 
Did you mean: 
DrGenious
Creator

Change Date Format

Hello,

Lets consider that we input files and they dont have the same date format. I want when I import them to change their date format.. For example We import a file with date format MM/dd/yy , another one with format yyyy/MM/dd and I want both of them to have the format of dd/MM/yyyyy. Thanks.

Labels (2)
1 Reply
fdenis
Master

so first detect date format, then convert to yours.

the best yay is to convert to date first then convert to string with format.