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 functions that can be used in the formula field, you can check out the support article titled "Formula Field Reference.")
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 specifier')," in which the format specifier can be something like 'DD-MM-YYYY,' 'YYYY/MM/DD,' 'MM.DD,' etc. (For a full list of supported format specifiers, please see this article.)
Eaten & " @ " & Location "–" & DATETIME_FORMAT(Date, 'DD-MM-YYYY')
Example (Just dates)
In this table, a formula has been set up in the primary field, using an autonumber field and concatenation, to create a unique record for each time that an experiment was performed. (For a more in-depth look at how to use formulas in the primary field with concatenation and autonumber, you can read the article titled "Using a formula in the primary field.")
"Experiment #" & {Test ID}
We'd like to add the date information to the record names to make them a little more specific. If you just type the field "Date" into the formula without using the DATETIME_FORMAT function, the formula will automatically try to display the time as well as the date—however, since there's no time defined in the date column, it ends up looking like this, with a superfluous "T00:00:00.000Z" after every date.
"Experiment #" & {Test ID} & "–" & Date
To avoid this, make sure to put the field whose date data you'd like to retrieve inside a DATETIME_FORMAT function.
"Experiment #" & {Test ID} & "–" & DATETIME_FORMAT(Date, 'MM/DD/YYYY')
Example (Date and Time, and the SET_TIMEZONE function)
You can also use DATETIME_FORMAT to configure the output for timestamps.
"Experiment #" & {Test ID} & "–" & DATETIME_FORMAT(Date, 'M/DD/YYYY h:mm')
Occasionally, you may encounter a problem in which the timestamps in the DATETIME_FORMAT are offset to GMT.
You can fix this problem in one of two ways. The easier way is by checking the "Use the same time zone (GMT) for all collaborators" in the date field's config menu.
You can also fix this manually by using the SET_TIMEZONE function inside of your DATETIME_FORMAT function. A complete list of Airtable's supported timezone identifiers can be found here.
"Experiment #" & {Test ID} & "–" & DATETIME_FORMAT(SET_TIMEZONE(Date, 'America/Los_Angeles'), 'M/DD/YYYY h:mm')