Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Created time modification

Topic Labels: Formulas
2984 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