1. Create a saved customer search. List > Search > Saved Searches > New > Customer.
2. On the results tab add Formula (Text) and enter the formula below:
Replace({createddate},'/','')
3. Save and Run the Search.
Note: There are instances when a user would want to pull up only numeric value of a field. Especially when this is integrated/imported to another system outside NetSuite.
Usual business use case is to create a unique numeric value which is used for tracking.
Please note that the formula can also be used on a custom field.
No comments:
Post a Comment