Concatenate formula to combine Date and Time into unique code

Georgie

When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025-01-01 which is how I need it to appear in the result. How can get the Concatenate formula to just reproduce the Date format from the cell it is referencing?

gorgs

Try this

=YEAR([UTC Start Date]@row ) + "-" + IF(MONTH([UTC Start Date]@row ) < 10, 0, "") + MONTH([UTC Start Date]@row ) + "-" + IF(DAY([UTC Start Date]@row ) < 10, 0, "") + DAY([UTC Start Date]@row ) + "T" + [UTC Start Time]@row + "Z"