Forum Discussion

GrantK's avatar
GrantK
Qrew Trainee
2 years ago

Pipeline - Advanced Query to search for records in the last week

Hi All, Just needed some help refining my advanced query to only search for records where a table's date field is from the last week.  I have a table which has a "Completed Date"  Date field (...
GrantK's avatar
GrantK
Qrew Trainee
2 years ago

The answer seems to be easier to solve by changing to a standard query and comparing to:

{{time.now - time.delta(days=7)}}

I'm assuming time.delta can't be used in an advanced query?. Also tried OAF instead of GTE.



------------------------------
Grant K
------------------------------