How to create a new column?

Question

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 DateNew Column19/7/20222022-00113/8/20212021-0028/2/20202020-003

Thank you!

Community help.xlsx

Felipe_Ribeir0 · Accepted Answer

Hi @LeoMessi

One way of doing this

davidskaife · Accepted Answer

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:

ShankerV · Accepted Answer

Hi @LeoMessi

Input:

Output:

Shanker V

DenisZ · Accepted Answer

Please see attached workflow, hope it helps

Feel free to mark it as solved if it solves the issue.