Date comparison question

[ptc-4667761]

Is there a way to write a query in Integrity that will compare dates? (ie. one date greater than another.)

[matt_giltaji · Accepted 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