Date Formula Error - Configuring help!

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

Hi @Elizabeth13

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

Here is a link just in case:

Here are some other links about formatting dates and times:


Perhaps you might find these links helpful.

Mary K

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)

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.