Skip to main content

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()


Reply