Hi, I am running a suiteQL-query through rest api/webservice against the Transaction table. The plan is to run a delta-load based on the last modified date in Transaction, but upon inspection I find some transactions where last modified date is greater than todays date. Currently testing in the QA/SB2-environment, so it could be an artifact of bad test data. Anyone who has found anything similar to this?

Probably just a timezone difference between the server and your local time

yes, just realized that. to follow up, the format of lastmodifieddata in the output of my query is date, although the documentation says it should be a datetime(https://5157020-sb2.app.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2020_1/analytics/record/transaction.html?mode=id). Can I somehow force this to be displayed as a datatime instead of a date?