Re: Date Formula Error - Configuring help!

503 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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:
AT Note View Problem

2 Replies 2
11 - Venus
11 - Venus

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

4 - Data Explorer
4 - Data Explorer

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)