Skip to main content

Date Formula Error - Configuring help!

  • January 1, 2020
  • 2 replies
  • 13 views
E

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

    2 replies

    M
    Forum|alt.badge.img+20
    • M_k
    • Inspiring
    • January 1, 2020

    Hi @Elizabeth13

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

    Here is a link just in case:

    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:

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


    Perhaps you might find these links helpful.

    Mary K

    M

    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)

    Terms & ConditionsAccessibility statement