When I run my query that has a MINDATE and MAXDATE column, i can see the full range of call dates. The earliest date is 06/04/2013 and the latest date is 06/19/2013.
When I run a report with text fields of MINDATE and MAXDATE off that query the range shows as 06/04/2013 to 06/04/2013...
what I am trying to accomplish is for the report to express the range of dates. the report asks the user to enter a begining date and an ending date for their search and I want them to know the actual range.
the data appears to be accurate but the dates don't work.
any ideas?
When I run a report with text fields of MINDATE and MAXDATE off that query the range shows as 06/04/2013 to 06/04/2013...
what I am trying to accomplish is for the report to express the range of dates. the report asks the user to enter a begining date and an ending date for their search and I want them to know the actual range.
the data appears to be accurate but the dates don't work.
any ideas?