Subject: | {today} in saved search's formula |
Date: | Fri, 13 Nov 2020 16:20:08 +0000 |
To: | "bug-NetSuite [...] rt.cpan.org" <bug-NetSuite [...] rt.cpan.org> |
From: | Vishal Gaikwad <vishal [...] saturotech.com> |
Dear Team,
As I was using the below formula in my saved search, the search was not executing as it was giving me a syntax error.
Formula : ROUND(to_date({today},'mm/dd/yyyy') - to_date({ccexpdate},'mm/dd/yyyy') ,0)
The NetSuite account I am using having a date format is 'mm/dd/yyyy' and my system's (my laptop) date format is 'dd/mm/yyyy'. The search should use NetSuite Account's date as {today} but it is using my system's date. Today's date is 13th NOV 2020, as the search picks my system's date and treat 13 as a month and gives the syntax error.
As I was checking, I changed my system dates format from 'dd/mm/yyyy' to 'mm/dd/yyyy' and then search worked properly.
So as per me, the search should pick today's date as per the NetSuite Accounts date that you are using.
Thanks and Regards,
Vishal Gaikwad
Saturo Technologies Private Limited
[www.saturotech.com]www.saturotech.com
Skype: vishal@saturotech.com<mailto:vishal@saturotech.com>
Mobile: +91 8087684936
ORACLE | NETSUITE<http://www.netsuite.com/>
[Description: Description: Description: Saturo Logo]
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us by replying to this email. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing, or taking any action in reliance on the contents of this information is strictly prohibited.