Thursday, November 1, 2018

Saved Search Formula to Pull up Year from a Date Field that works the same way as the "Year" Function

To pull up the year from a date field in NetSuite saved searches, the user can add the following formula under the Results tab > Columns subtab.                                      

Formula (Text) | TO_CHAR({field ID},'fmYYYY')

For example:

The formula for the Date field on sales records/forms such Sales Order and Invoice must read as follows:  Formula (Text) | TO_CHAR({trandate},'fmYYYY'). 

So if Date = 2/29/2012, then the formula column must display "2012".

If you add this formula: Formula (Text) | TO_CHAR({trandate},'Year'), using the same Date sample, the formula column must display "Twenty Twelve".

 

No comments:

Post a Comment