Jump to content
  • 0

Criteria Based On Different Field


jeffs88keys
 Share

Question

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 !!!

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...