Change Format of DATE field in saved search result

Hi,

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

YYYY-MM-DDThh:mm:ss

Any idea?
Thanks,

Ma

Beginner Asked on December 10, 2019 in How To's.
Add Comment
1 Answer(s)

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

Ma

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’)

Ma

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.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor   Become a Sponsor