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