AnsweredAssumed Answered

NetSuite query by lastModifiedDate

Question asked by hubidubi on Oct 2, 2018
Latest reply on Oct 2, 2018 by britto.parthalomew

I would like to query NetSuite Vendors by lastModifiedDate:

 

 

The parameter for the filter is set to Last Successful Run Date.

When I run the query, I got the following logged values:

 

current date: 2018-10-02T13:43:08-0700
Last Successful Run Date: 2018-10-02T13:38:29-0700
lastModifiedDate date of fetched NS record: 20181002 072158.000

This is a snippet from NS response containing the same value above, but clearly shows the timezone<lastModifiedDate>2018-10-02T07:21:58.000-07:00</lastModifiedDate>

 

As it looks like the lastModifiedDate is before than Last Successful Date, so the related record shouldn't be fetched.

I would like to fetch# those record only that were changed after the last successful run.

Outcomes