Date Formula Error - Configuring help!

[Elizabeth13]

I can’t figure out where I am going wrong in my formula below. It seems like it should be simple, but maybe I am going about it the hard way.

I have:
{Created Time} & " - " & {Notes}

I want to have the Primary Field display the created date and time in the MM.dd.yyyy - HH:mm format and add the data from the Notes field to the end - so it would look like this:

MM.dd.yyyy HH:mm - Notes field

Any help would be appreciated! Please see attached image of my table.

Thanks - and Happy New Year! :partying_face:
Elizabeth

[M_k]

Hi @Elizabeth13

Perhaps it might have to do with time zones? Just an idea.

Here is a link just in case:

Airtable - Support

Supported timezones for SET_TIMEZONE

The SET_TIMEZONE function will allow you to set the timezone for the data from a date type field. This is written in the form "SET_TIMEZONE(datetime, 'timezone identifier')," in which the...

Here are some other links about formatting dates and times:

Airtable - Support

Formula field reference

For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...

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...

Perhaps you might find these links helpful.

Mary K

[Milton_Villarre]

Hola según entiendo quieres unir Created Time, - , y Notes, para ello debes crear otra columna tipo formula y agregar lo siguiente: CONCATENATE(Created Time, " - ",Notes)