I am writing a SOQL query in Apex like:
Select Id From Case Where Day_Only(Date_Time_Order_Received__c) >= :startDate
But it seems to me that the Day_Only function will calculate the datetime field based on GMT time. Is there a way to use log in user's time instead of GMT time?
I second opinion expressed by NSJonas above
Paymentdate will be in EST, provided user who has scheduled the job is also in EST time zone. Please verify that first. Seems like GMT date is converted into EST but is compared with some date in some other timeZone
I did a simple test : created a new scheduled Job with just debugging statements like this :
global class DateTimeZoneCheck implements Schedulable {
global void execute(SchedulableContext SC) {
system.debug(date.today());
system.debug(system.now());
}
}
Date.today() was printed in debug log , in time zone of user who has scheduled the job while System. now was in GMT like this :
The CloseDate field is of the Date type. That means you should not include a time component in your filter value. This query works for me in the Developer Workbench. Should be the same for you in Postman, I'd think.
/services/data/v36.0/query?q=Select+Id+from+Opportunity++where+CloseDate+<+2016-07-31
Specifically, the date format is 2016-07-31.
Best Answer
SOQL has a function called
convertTimezone()that you can use in other date functions to return the value converted to the user's timezone:Converting Time Zones in Date Functions
For Info: