Criteria Based On Different Field

[jeffs88keys]

I have a sales tracking app.  2 fields in question are:

 

Date of salesperson hire

Invoice date of sale

 

I'm looking to create a report with 2 criteria.....the first is that the salesperson had to be hired in 2015.  That's easy.

 

The 2nd criteria is that the invoice date of the sale must be greater or equal to the Date of salesperson hire, but less than or equal to Date of salesperson hire +360.

 

So I'm no html or java programmer, but I think this is probably pretty easy.

 

Can someone help me with this one?

 

Thanks so much !!!

[MayMusic]

add a Formula Field to your table to calculate one year after sales person hire using formula below

Dateadd(year,1, [@field:SalesPersonHireDate])

Then in your configure Filtering filed you need to include this Formula field and select Less than or equal as comparison type