Does anyone have a link for NetSuite formulas? Ev...
# general
r
Does anyone have a link for NetSuite formulas? Even more specific, does anyone know the formula for a search that is looking for how many days since the customers' last purchase?
j
"SQL Expressions" SuiteAnswer ID 10101. "Saved Search That Displays the Number of Days Since the Customer's Last Purchase" SuiteAnswer ID 12701.
r
Thank you, I found that one, but when used that exact formula, I get this error:
j
try returning each field individually ({today} and {trandate}) as a formula (date) to see which field is the issue. Guessing the former, but good to confirm.
also did you filter to the transaction types specified in the article? Could be you're pulling others that don't have a trandate.
r
Hi, I've tried both suggestions and still no luck...I've reached out to support at this point. Thank you so much for your effort!
j
okay, gl. So both fields worked fine individually, but not together in a formula? That is really weird if so netsuite
m
formula numeric : CASE WHEN {trandate} IS NOT NULL THEN FLOOR(TO_DATE({today}) - {trandate}) ELSE NULL END
or