Anyone seeing issues recently with date filters on...
# generalg
GeneralKenobi
08/04/2023, 2:03 PMAnyone seeing issues recently with date filters on their saved searches? When filtering by the from date the results are off by a day. Ex i am filtering from 8/2/2023 and my results start from 8/3/2023. This started last week Thursday and it is all our saved searches.
e
eblackey
08/04/2023, 2:22 PMCurious, what type of record? Native record type or custom type? The reason I ask is that there are different date field datatypes in the underlying NetSuite data model.
eblackey
08/04/2023, 2:24 PMI just sampled transactions with a date filter on “trandate” and I did not see this result. I see transactions starting 8/2/2023.
e
Edgar Valdes
08/04/2023, 3:27 PMIt happened to me the other day in the SOAP Web Services Usage Log. Today is working fine.
g
GeneralKenobi
08/04/2023, 4:52 PMI will double check its mainly our transaction records, SuiteQL queries works fine no issues its just the searches using the filter
r
RJMNS
08/04/2023, 4:55 PMDid someone change your account timezone?
RJMNS
08/04/2023, 4:56 PMI'd think the filters should update, but if it got changed to UTC or something versus [your time zone], maybe that would cause issues.
g
GeneralKenobi
08/04/2023, 4:58 PMThats what i was thinking as well
GeneralKenobi
08/04/2023, 4:58 PMThanks everyone