cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - If community subscription notifications are filling up your inbox you can set up a daily digest and get all your notifications in a single email. X

Date comparison question

ptc-4667761
1-Newbie

Date comparison question

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

View solution in original post

1 REPLY 1

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

Top Tags