I am working on a query that I would like to show only record concerned with the beginning date mm/dd/yy where the ending date will be one month only. I've tried ">=[Enter Beginning Date:] + ("m", [Beginning Date] + 1) and this does not work. If anyone got and idea, please let me know.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Parameter
- Thread starter Shirley
- Start date
You don't mention the field names, but it sounds like you're not applying the begindate criteria to the begindate field, and the enddate criteria to the enddate field. Try this:<br>
<br>
Put your beginning date criteria in the beginning date column.<br>
Build a calculated column such as "Months" -> Months
ateDiff("m",BeginDate,EndDate)<br>
Give your "Months" column a criteria of 1.<br>
<br>
<br>
<br>
Put your beginning date criteria in the beginning date column.<br>
Build a calculated column such as "Months" -> Months
ateDiff("m",BeginDate,EndDate)<br>Give your "Months" column a criteria of 1.<br>
<br>
<br>
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question