Has anyone been able to make a call with SuiteQL t...
# suitescript
d
Has anyone been able to make a call with SuiteQL that with a WHERE lastmodifieddate >= ‘2020-11-24 000000’?
t
@digiconz Try something like this:
WHERE lastmodifieddate >= TO_DATE( '2020-11-24 00:00:00', 'YYYY-MM-DD hh24:mi:ss' )
Or, if you don't really need the time precision:
WHERE lastmodifieddate >= TO_DATE( '2020-11-24', 'YYYY-MM-DD' )
s
you should also be able to use a string directly - if it's passed in your netsuite standard format. though I think @tdietrich approach is safer
d
But won’t this truncate it to just a date? I want to find records that have changes after a certain DATETIME
t
Ok, so then I think you'll want to use the first one. 'YYYY-MM-DD hh24miss'
d
Thanks @tdietrich
we got it working
t
No problem. I ran into that, too - and yeah, it's very frustrating.
134 Views