Date in Formula without hyphen

Hello Together

I have the following table design:
Column “Invoice date” - Type “Date” - Example value: 2021-12-30
Column “Customer code” - Type “Name” - Example value “awc”.

Now I want to compose an invoice number from these two fields using a formula. Invoice date & “_” & {abbreviation}
My output will look like this: 2021-12-30T00:00:00.000Z_awc
But how the output should look like: 211230_awc

How can I solve this cleanly using a formula?

use DATETIME_FORMAT()

2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.