OR statement syntax help please.

[BreffniK]

Thanks for taking the time to look at my question.

Version 8.5:

Backround:

I have created two fields (let's call them DelayTime1 and DelayTime2) which calculate the number of days a record is past due by subtracting date_time fields one another. I have tested these fields and they're working correctly.

I would like to use these fields on a subreport to filter out records that are not past due (IE, only return records where DelayTime1 > 0 or DelayTime2 >0).

My question(s):

Do I have to combine the above logic into a new formula field and then filter according to that field? If so, what is the syntax I would use on that new field?

If not, how else might I develop this filter?

 

[lbass]

You would add the following to the record selection formula (report->edit selection formula->record) in the subreport:

{@DelayTime1} > 0 or
{@DelayTime2} > 0

Of course, whether you can use this depends on the contents of your formula. If it doesn't work, please provide the formula contents.

-LB