Discussions
Read on for the latest updates including:
• Agenda Builder launch
• SuiteWorld On Air registration
• New NetSuite Prompt Studio Contest
• And more!
Check out this thread to learn more!
Date calculations/Comparisions
Hi All
I'm trying to do a search for tickets last updated in the last 24h, but I'm having problems comparing different format dates:
Last Modified Date is: 30/11/2012 13:56 (from existing ticket)
todaysDate is Fri Nov 30 2012 07:21:19 GMT-0800 (PST) (generated from var todaysDate = new Date(); )
yestDate is Thu Nov 29 2012 07:21:19 GMT-0800 (PST) (calculated as todaysDate - 24 hours)
When I then run the following, it doesn't seem to work. Is it because the formats are different?
If so, how do a re-format them to work in the filter below
filters[2]=new nlobjSearchFilter("lastmodifieddate",null,"within",yestDate, todaysDate);
Thanks in advance