Saturday, September 29, 2018

Change the Date format on Search result using a Formula to YYYY/MM/DD.

To change the Date format on Saved Search results:

 

Example:

From = MM/DD/YYYY

To = YYYY/MM/DD

 


1. On Customize Save Search page > under Results tab > Columns subtab.
2. Add Formula (Text).

3. On the Formula field, add TO_CHAR({trandate},'YYYY/MM/DD').

4. Click Add.

5. Save & Run

 

No comments:

Post a Comment