Criteria expression question

[rbrule]

Hello.
I have a table with two important dates, Date 1 and Date 2. I need to query only those records for which the difference between date 1 and date 2 is greater than thirty days. I created a calculated field and subtracted date 1 from date 2 and used the results for the criteria in my query, which worked out fine.

Is there a better way to do this, through use of an expression in the criteria field?

 

[dcx693]

You can use an expression like this in the critiera line of [Date2] or [Date1], assuming those are the names of the fields:
[Date2]-[Date1]>30

 

[rbrule]

Thank you very much. I appreciate your help