Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Date in Formula without hyphen

Topic Labels: Dates & Timezones
314 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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?

1 Reply 1

use DATETIME_FORMAT()