RE: Change Format of DATE field in saved search result


Do you know how to transform a date into the following date format:


Any idea?


Ma Beginner Asked on December 10, 2019 in How To's.
Add Comment
1 Answers

In the Results tab, add Formula (Text).

Enter the following formula in the Formula column: TO_CHAR({xxxx}, ‘YYYY-MM-DD HH:MM:SS’)

XXXX – field’s ID

Beginner Answered on December 10, 2019.

Hello Asaf,

That works for the first part, but how do I build YYYY-MM-DDThh:mm:ss

as 2019-12-10T15:13:00


on December 10, 2019.

Hello Ma,

please try this formula – TO_CHAR({trandate},’YYYY-MM-DD’)||’T’||TO_CHAR({trandate},’HH:MM:SS’)

on December 10, 2019.

Thanks for your answer Asaf!

I made it work with: TO_CHAR({today}, ‘YYYY-MM-DD’)||’T’||TO_CHAR({today}, ‘hh24:mm:ss’)


on December 10, 2019.

One correction. To get minutes, you need to do “MI” not “MM”. If you use MM, the month value will be returned.

on May 31, 2022.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.