Crystal Reports 2008, Oracle 11g - Capture datediff 2 days before and 2 days after

[hmax]

I need to create a formula that captures the following:

{table.field} >= datediff({table.fieldA},{table.fieldB}) where the datediff result is a range of 2 days before and 2 days after.

Thanks,

hmax

 

[IanWaterman]

Please clarify

datediff result is a range of 2 days before and 2 days after

Relative to what?

Please show same data and what you wnt to show in your formula

Ian

 

[hmax]

So, clearer requirements below:

Capture a case that was created 2 days prior to, or 2 days after, the first commission date (commission date is a site attribute string field that will be converted to a date)


{CaseTable.CreationDateField} is 2 days prior to the first datevalue({SiteAttributeTable.CommissionAttributeField})
or
{CaseTable.CreationDateField} is 2 days after the first datevalue({SiteAttributeTable.CommissionAttributeField})


Thanks, IanWaterman.

 

[lbass]

{CaseTable.CreationDateField} < date({SiteAttributeTable.CommissionAttributeField})-2 or
{CaseTable.CreationDateField} > date({SiteAttributeTable.CommissionAttributeField})+2

-LB

 

[hmax]

Thanks, lbass! I had a brain freeze. Going in too many directions at once! Bye.