This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

```Your formula has an error in it.  It could resolve to the wrong datatype, use an unknown function, or have a syntax error.  Please go back, correct the formula, and re-submit.&lt;BR&gt;&lt;BR&gt; Search: Transaction Search&lt;BR&gt;Formula: TO_DATE({12/20/2024 7:29:00 am}, 'YYYY-MM-DD HH24:MI:SS') - {datecreated```


&gt;*AI generated answer (using internal Slack threads):*
Based on the conversations, it seems like the error in your formula is due to the incorrect usage of the `TO_DATE` function. In your formula, you are trying to convert a string into a date, but the string is not in the correct format. The `TO_DATE` function expects the date string to be in the format 'YYYY-MM-DD HH24:MI:SS', but you are providing it in a different format.

Here is the corrected formula:

```TO_DATE('2024-12-20 07:29:00', 'YYYY-MM-DD HH24:MI:SS') - {datecreated}```

Please replace '2024-12-20 07:29:00' with your actual date and time.

Remember, the result of subtracting two dates is a number (the difference in days), so you should use Formula(Numeric) instead of Formula(Date).

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1600210901395700|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.866987288

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1690319729679049|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.863373458

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1631124534405100|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.861137927



Please provide your feedback on this answer.