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

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

Date comparison question

ptc-4667761
1-Visitor

Date comparison question

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

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

Announcements


Top Tags