Extract numbers from date

[SebIEB]

Hello guys!

I am new here in Airtable and I hope you can help me in the following problem.

I have two collumns, called “REF” and “Date of show”.

What am I trying to do is the following, from the date of show row, to extract numbers in order to create a code. To be more exact, I will give you an example of what I want to do:

Date of show: 11/02/2017
REF: 11022017SF

The formula that I have tried to use is the following and I am getting an error:

DATETIME_FORMAT({Date of contract}, ‘MMDDYYYY’)& “SF”

Thank you very much for the support!

[Elias_Gomez_Sai]

I think the formula is OK, so I can only think that the date parameter is not a date. Which type of field is it? Is it filled?

I leave you some docs

Airtable - Support

Formulas and date fields

If you would like to incorporate the data from a date-type field into a formula field, the best way to do this is by using the DATETIME_FORMAT function. (For more information on the different funct...

Airtable - Support

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the form "DATETIME_FORMAT(Datetime, 'format s...

[Elias_Gomez_Sai]

I have it working:

Formula: DATETIME_FORMAT(Date, 'MMDDYYYY')& "SF". Are you using the correct quotation marks?

[SebIEB]

Thank you very much for support guys!
You are amazing! :grinning_face_with_big_eyes:

[Elias_Gomez_Sai]

You solved it? What was the problem?