Why is onorbefore not matching records with the current trandate equal to 28-Jan-2025 in the following search filters. Are there caveats of "onorbefore" date filter? [["type","anyof","SalesOrd"],"AND",["mainline","is","F"],"AND",["shipping","is","F"],"AND",["status","anyof","SalesOrd:B","SalesOrd:D"],"AND",["item.isfulfillable","is","T"],"AND",["trandate","onorbefore","28-Jan-2025"]]

AI generated answer (using internal Slack threads):

The "onorbefore" filter in NetSuite is used to match records where the date is on or before the specified date. However, it's important to note that this filter only compares the date part and not the time. This means that if a transaction was made on "28-Jan-2025" but at a time later than when the search was executed, it will not be included in the results. Another important aspect to consider is the timezone of your account. If the timezone was recently changed, it could cause discrepancies in the search results. NetSuite stores all dates in UTC and then converts them to the user's timezone when displaying them. So, if your account's timezone is different from UTC, the "onorbefore" filter might not work as expected because it's comparing the dates in UTC. Lastly, if you're trying to compare two different date fields, you might need to use a formula in your search criteria. For example, you could use a formula like

CASE WHEN {date1 field} = {date2 field} THEN 1 ELSE 0 END

and set it equal to 0 to find records where the two dates are different. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******