Help

Created time modification

Topic Labels: Formulas
2790 5
cancel
Showing results for 
Search instead for 
Did you mean: 
Inkoming
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi,

I’m using the created time field in my database when I receive a new messages that are stored in the database. Is there a way to modify it to display it right that?

Dec 23, 2019 8:23 pm

Thanks!

5 Replies 5
AlliAlosa
10 - Mercury
10 - Mercury

Hi there! The following should display CREATED_TIME() as a string in the format you want :slightly_smiling_face:

DATETIME_FORMAT(CREATED_TIME(), 'lll')
Inkoming
5 - Automation Enthusiast
5 - Automation Enthusiast

Woaw! That’s amazing! Do you know how could I just modify the PM and AM into pm and am please?

Hi @Inkoming

I found a link on the web with a list of date formats.

Hope it helps.
Mary K

Inkoming
5 - Automation Enthusiast
5 - Automation Enthusiast

That was exactly what I needed.
Thank you very much, my problem is now solved.

Great! Glad to know @Inkoming.

Mary K