Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Datetime_format trouble

Topic Labels: Formulas
258 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Trying to auto create a unique key in a table used for tracking grazing on a cattle farm.
So my current formula is
“(Pasture & DATETIME_FORMAT(Date, ‘M/D/YYYY’)”
Where “Pasture” and “Date” are both fields in the table.
Any help?

2 Replies 2

By putting the whole formula in quotes you’re telling Airtable to literally type “DATETIME_FORMAT” and not process the function. If you take the quotes and parenthesis at the beginning away it should work:

Pasture & DATETIME_FORMAT(Date, 'M/D/YYYY')

If you want to add a space between the two:

Pasture & ' ' & DATETIME_FORMAT(Date, 'M/D/YYYY')

If needs unique number you can use recordID

Pasture&’ ‘&DATETIME_FORMAT(Date, ‘M/D/YYYY’)&’ - ID=’&RECORD_ID()