Friday, May 17, 2019

Change the format to Day, Mon. DD, YYYY of Date fields on Search results using Formula SQL

To change the format of different Date fields on Saved Search results:
From = 10/31/2013
To = Thursday, Oct. 31,2013

Date fields can be any of the following:

a. Date  = {trandate}
b. Date Created = {datecreated}
c. Due Date = {duedate}
d. Date Billed = {billeddate}
e. Date Closed = {closedate}
f. Start Date = {startdate}
g. End Date = {enddate}

1. On Customize Save Search page > under Results tab > Columns sub tab.
2. Add Formula (Text)
3. On the Formula field, add TO_CHAR({trandate},'Day, Mon. DD, YYYY')
4. Click Add
5. Click Save & Run

No comments:

Post a Comment