I have a 2 datetime field(Start_Time__c and End_Time__c) and I need to compare them with current time.
I am writing the following SOQL Query :
Select id from objTime where Start_Time__c >= SystemTime.now() AND End_Time__c
But it is unable to fetch to the comparison of date time, do we have any solution for resolving the same ?
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 :
Tinkered around with this for a bit and here's one workable method. Have a field updated to today's date, have a second time based workflow activate 14 hours after today's date field. That will reliably kick off a process at 2pm according to your org time, whole hours only allowed unfortunately.
For your second request though for a comparison of date time for current date.
DateTimeValue takes a literal string, so you can pass it the required date, add the specific time required for the comparison:
IF(NOW() < DateTimeValue("2016-11-09 09:30:00"),'true','false')
edit: just a reminder that if you're trying to trigger something from a formula, formula changes do not kick off workflow recalculations.
Best Answer
You can use static or dynamic SOQL here. It would be as below
Static soql:
Dynamic soql:
List<Account> accounts = Database.query('SELECT Id From Acccount WHERE Start_Time__c >= :currentTime AND End_Time__c <= TODAY ');I tried this on account , you can use this on any sobject. As a common practice if this helps mark this as solution.