Fstetson
New member
- Local time
- Yesterday, 16:36
- Joined
- Nov 12, 2020
- Messages
- 11
Good Day all,
I have a unique situation where I have set up a series of reports for different areas to show data between user input dates. The uniqueness comes with the field (in the report query). I am applying the parameter criteria of Between [Enter the Start Date] And [Enter the End Date] in the field I have named Event Date, within a custom nested IIF statement. I cannot seem to be able to get the criteria to filter for the date range. I attach a Text FILE with the SQL Statements and screen shots. Trying to be brief as possible in forum.
If someone could please advise on how to do this right...I would appreciate it greatly. . I have found nothing online through google/bing searches. Has to be something simple I am missing, or maybe not. My database is foundationally based on Allen Browne's Recurring Task DB.
Thank you all so much!
Fred
I have a unique situation where I have set up a series of reports for different areas to show data between user input dates. The uniqueness comes with the field (in the report query). I am applying the parameter criteria of Between [Enter the Start Date] And [Enter the End Date] in the field I have named Event Date, within a custom nested IIF statement. I cannot seem to be able to get the criteria to filter for the date range. I attach a Text FILE with the SQL Statements and screen shots. Trying to be brief as possible in forum.
If someone could please advise on how to do this right...I would appreciate it greatly. . I have found nothing online through google/bing searches. Has to be something simple I am missing, or maybe not. My database is foundationally based on Allen Browne's Recurring Task DB.
Fred