in a customer saved search, is there any way to ge...
# general
t
in a customer saved search, is there any way to get more granular with the "customer date created" than day? For example if I want a search to return records that were created over an hour ago, how would I go about doing that?
l
I think you can use the date from Systen notes fields... Using criteria where type is create
t
could you elaborate? I know I can set a criteria of System Notes: Type is create, but I don't see how that gets me closer
I need for it to return records that were created over an hour ago
g
message has been deleted
note, that value in the formula numeric is not exactly an hour
t
wow, I've never actually done something like that before. Thanks for pointing me in the right direction. I have much to learn
g
Date formulas are a bit of a pain some times...and i've never had to subtract anything other than days/months from a date. Not sure how it would be done more accurately for an hour. I'm sure it can be, but this could probably help in a pinch. I'd bring in the date field in your results to be extra sure.
t
it's not important that it's exactly an hour, just needs to be close
g
Hopefully this helps!
t
thanks!