Hello!
I want to add a new column in my dataset, using transaction date in DDMMYYYY format, and transform it into YYYY-0001 format. A sample is below:
Transaction Date | New Column |
19/7/2022 | 2022-001 |
13/8/2021 | 2021-002 |
8/2/2020 | 2020-003 |
Thank you!
Solved! Go to Solution.
Hi @LeoMessi
Here is a way of doing it using DateTime formula and a Record ID. Firstly create a record ID field in string format, specifying the length of the field, then parse the date into standard ISO format, format so it's only the year, and finally add the record ID to it:
Hi @LeoMessi
Step 1: Input
Step 2: Record ID tool
Step 3: Regex tool
Step 4:
Kindly accept this solution if it provided a solution to your question.
Many thanks
Shanker V
Thank you, everyone!
Your respective solutions worked for me!!