You need to sign in to do that
Don't have an account?
Srini
How to get the query the data that has been modified in last 24 hours .
Hi All,
How to get the query the data that has been modified in last 24 hours ?
Can any one helpme on this query
Thanks in advance
How to get the query the data that has been modified in last 24 hours ?
Can any one helpme on this query
Thanks in advance
Please try below query:
Thanks,
Vedashri
Please mark this as the best answer if this helps
The ablove query has showing for all Account records.But i want to show who ever updated in last 24 hr.
We are mentioned like below:
Select Id from Account where LastModifiedDate >= 2014-11-19T23:01:01Z
thanks
Please mark this as the best answer if this helps
Have you tried below query?
Yes,I have tried when we are using the single query it has getting the records like who ever modified the reeocrds from last 24hrs,but we have implemented the some code in that it is not working.
Thanks
Can you share your code here? Need to check how it is used, so that I can try solution.
Plese find the below code :
Select Parent_ID__c, Min(Fine_Date_Formula__c) Symbol_StatusDate from Account where Parent_ID__c!=Null and Fine_Date_Formula__c!=Null and LastModifiedDate >= LAST_N_DAYS:1
Please check and help me
Thanks
Sorry for delay. I feel you don't have any record which matchs your WHERE condition. Please check once.
I have excecuted similar query in dev console. It is working fine for me.
Please let me know if that is also not working for me.
Thanks,
Vedashri
Ok, we will try and let you know
Thanks for your reply.
Regards.