SQL formula that Counts the Number of Days in a Month for Searches

To generate number of days in a month on Transaction searches.

 

Example:

January = 31

February = 29

March = 31

April = 30  

1. On the customize saved search page > under Results tab > Columns Sub tab.
2. Add Formula (Text).

3. On the Formula field, add TO_CHAR((last_day({trandate})),'DD').
4. Click Add.

5. Save & Run