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

Any reason why TRUNC({today},'D') results to 01/23/2021 instead of 01/25/2021 in a transaction saved search?

I also tried TRUNC({datecreated},'D') results to 01/16/2021 instead of 01/21/2021 (based on my data)?

I can't remember is date created a date/time?

Also - {today} may not be taking the NS account time into effect.

D means start of the week, so because its USA system, they start on Sunday, instead of Monday as other world.

<https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions230.htm#i1002084>

Oh I got it now. That makes sense. Thank you both!