troubleshooting Question
Date diff nresults
asked on
How to filter a query by parameter dates , the total for Novemember 2018 minus December 2018 total , because the users will not be able to see the actual quary I have a ttached a parameter form binded to a query which has the details.
The form has two date parameter ( [start date] to [End date]) where they will fill in , for example the difference for December 2018 is calculated the following:
<= Start AND End date
The problem here isntead of start from 30/11/2018 it is start from 1/12/2018, so how do I make sure that the picked results start from 30/11/2018 isntead of 01/12/2018
SalesMonth salary Cumm Commission
Jan-18 10500 10500 2625
Feb-18 10500 21000 5250
Mar-18 10500 31500 7875
Apr-18 10500 42000 10500
May-18 10500 52500 13125
Jun-18 10500 63000 15750
Jul-18 10500 73500 18375
Aug-18 10500 84000 21000
Sep-18 10500 94500 23625
Oct-18 10500 105000 26250
Nov-18 10500 115500 28875
Dec-18 10500 126000 31500
Regards
Chris
The form has two date parameter ( [start date] to [End date]) where they will fill in , for example the difference for December 2018 is calculated the following:
<= Start AND End date
The problem here isntead of start from 30/11/2018 it is start from 1/12/2018, so how do I make sure that the picked results start from 30/11/2018 isntead of 01/12/2018
SalesMonth salary Cumm Commission
Jan-18 10500 10500 2625
Feb-18 10500 21000 5250
Mar-18 10500 31500 7875
Apr-18 10500 42000 10500
May-18 10500 52500 13125
Jun-18 10500 63000 15750
Jul-18 10500 73500 18375
Aug-18 10500 84000 21000
Sep-18 10500 94500 23625
Oct-18 10500 105000 26250
Nov-18 10500 115500 28875
Dec-18 10500 126000 31500
Regards
Chris
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Most Valuable Expert award recognizes technology experts who passionately share their knowledge with the community, demonstrate the core values of this platform, and go the extra mile in all aspects of their contributions. This award is based off of nominations by EE users and experts. Multiple MVEs may be awarded each year.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.