Wednesday, January 2, 2019

Remove Slashes on the Date Field in Saved Search Results

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