Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X
Is there a way to write a query in Integrity that will compare dates? (ie. one date greater than another.)
Solved! Go to Solution.
There are query filters for dates in a specified range, so you could use that to get to a basic grater than or less than.
For example, getting all items with create date > Jan 1st, 2013 could be created date between Jan 1st, 2013 and some date way in the future.
If you are looking for a query with a date field greater than another date field, I am not sure if you can do that in a query directly.
An alternative to mimic that functionality is to create a computed logical field which performs the date field comparison, then query for items where that logical field = true.
Matt
There are query filters for dates in a specified range, so you could use that to get to a basic grater than or less than.
For example, getting all items with create date > Jan 1st, 2013 could be created date between Jan 1st, 2013 and some date way in the future.
If you are looking for a query with a date field greater than another date field, I am not sure if you can do that in a query directly.
An alternative to mimic that functionality is to create a computed logical field which performs the date field comparison, then query for items where that logical field = true.
Matt