Avatar of brihol44
brihol44
 asked on

I'm not quite sure how to pull all records that have not been updated from within 10 minutes + 30 days.

Hello,

I'm not quite sure how to pull all records from within 10 minutes + 30 days. So if a record hasn't been updated 30 days + 10 minutes from the date and time of now is what I'm looking for.

SELECT record_ID
FROM users
WHERE date_added <= 30 days + 10 minutes

Thanks for the help,

Brian
ColdFusion Language

Avatar of undefined
Last Comment
brihol44

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
_agx_

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
_agx_

Did the edited code work okay?
brihol44

ASKER
Sorry for the delay AGX... That worked! Thank you!
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck