Hi @Angela Diallo? , thank you for your question.
You've written a change from the year 1982 to the year 1983. I assume you don't mean a difference in the year, but only a change in the date format? i.e., from JUL 23 1982 to 07/23/1973?
If so, there are 3 ways to do this.
1 . change datatype first
First, make sure you find the correct date\time column data type:
That starts with 'shortMonth' for the 3 characters representing a month.
Then, use the 'date format' transform and choose your output format:
2 . use a custom input format
without fitting the date\time column data type, you can use the advanced option in the 'date format' transform to have a custom input date format as well:
3 . use 'transform by example'
You can use the tool 'transform by example' to explain to Trifacta what is the format you want - and Trifacta will apply it to all the other dates:
This works even while the column is still a string.
Please also see this knowledge-based article for reference.
I hope that helps; please feel free to ask any additional questions.
Thanks,
Amit.
Good question ?
Good question ?