RE: 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
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
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
Hello Ma,
please try this formula – TO_CHAR({trandate},’YYYY-MM-DD’)||’T’||TO_CHAR({trandate},’HH:MM:SS’)
Thanks for your answer Asaf!
I made it work with: TO_CHAR({today}, ‘YYYY-MM-DD’)||’T’||TO_CHAR({today}, ‘hh24:mm:ss’)
Ma
One correction. To get minutes, you need to do “MI” not “MM”. If you use MM, the month value will be returned.
