You need to sign in to do that
Don't have an account?
Yogendra Rishishwar
how to get current Date in SOQL
How to get current Date time in Salesforce Object Query Language .
Suppose I want to get all cases which have been closed in last 30 days then what should be query .
Select CaseNumber from Case where ClosedDate >= CURRENT_DATE - 30 Days ;
What date function will return cirrent date in SOQL?
Thanks
Yogendra Rishishwar
Suppose I want to get all cases which have been closed in last 30 days then what should be query .
Select CaseNumber from Case where ClosedDate >= CURRENT_DATE - 30 Days ;
What date function will return cirrent date in SOQL?
Thanks
Yogendra Rishishwar
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_date_functions.htm
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm
You can try LAST_N_DAYS:n All below fucntion are helpfull for you
LAST_MONTH
LAST_90_DAYS
LAST_N_DAYS:n
Please let us know if this will help you
Thanks
Amit Chaudhary
All Answers
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_methods_system_datetime.htm
Here you can see Date Literals for SOQL:https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_date_functions.htm
https://developer.salesforce.com/docs/atlas.en-us.soql_sosl.meta/soql_sosl/sforce_api_calls_soql_select_dateformats.htm
You can try LAST_N_DAYS:n All below fucntion are helpfull for you
LAST_MONTH
LAST_90_DAYS
LAST_N_DAYS:n
Please let us know if this will help you
Thanks
Amit Chaudhary
My Problem got resolved,
Thanks again.
SELECT Id, CreatedDate, Destination_System__c, Method_Name__c, Request_Timestamp__c, Response_Timestamp__c, Response__c, Source_System__c, Status_Code__c, Status__c, User_Name__c
FROM Sys_Log_Integration__c WHERE CreatedDate = TODAY