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