Skip Menu |

This queue is for tickets about the NetSuite CPAN distribution.

Report information
The Basics
Id: 133735
Status: rejected
Priority: 0/
Queue: NetSuite

People
Owner: Nobody in particular
Requestors: vishal [...] saturotech.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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.
Outlook-Descriptio.png
On 2020-11-13 08:20:24, vishal@saturotech.com wrote: Show quoted text
> 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.
This doesn't seem to have anything to do with the perl bindings for NetSuite, which is the issue queue you submitted to.