Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Can a search compare two date fields in a record?
We are on NSSB..
Most of our customers order on a regular basis..
We have a custom field in the customer record where we manually update the last order date (while we are waiting for the last_order_date field enhancement).
Anyway, sometimes the order gets entered, but we forget to update this field.
I'm trying to create a search that would show any records where the "Transaction:date (maximum)" is greater than our custom field "last order date".. but can't seem to figure out how to compare two fields using the search form in NSSB.
Can anyone help me out with this one?