Date Range on Report

[Reyesii]

Hello:

I am trying to create a report that uses the Define filter arguments. One of the arguments is date. When I run the report, a form appears which I am able to select arguments. The problem is that when I enter the date range it does not work. I get all the records as if I had entered nothing at all. The other augments work, its just the date that seems to be ignored.

My question how do I enter a data range so the report works properly?

This is how I am entering the date range in my form.
1/1/2015 - 2/30/2015

[workaholic06]

Re: Date Range on Report

Hi Reyes,

You can define arguments, but in order to filter the data, you need to include them in the WHERE clause of your Select statement.

[Reyesii]

Re: Date Range on Report

Earl:

I don't see an option on the report to use SQL. I only see the form that is used to select the options when i select the "Define filter arguments". This creates a from that the user fills in prior to running the report. When I run the report I fill in the date range. Unfortunately it does not give you a clue as to how to format the date. So I assumed it is Date1 - date2 or 1/1/2015 - 2/30/2015. It does not give me an error when, but the results are not filtered.

I will check to see if SQL is an option on Reports. I assume it is.

[workaholic06]

Re: Date Range on Report

Ok - sorry - you're probably using DBFs - which is out of my area.

Date format should be mm/dd/yyyy but i don't know if a single date filter argument would allow for a date range using DBFs - maybe someone else with DBF report experience can respond?

in SQL, we define a 'startdate' and 'enddate' filter, and then in the WHERE clause, specify the filter: WHERE mydate BETWEEN :startdate AND :enddate

[GGandhi]

Re: Date Range on Report

I also don't do with dbf but the steps are the same
go to the top on the report, click on report then select records then when the pop up comes up the top one is filter.
click the expander on the right and select your date field and arguments for example
your_date_field > start_date argument .and. your_date_field < end_date_argument
this should bring the records in question I am sure.

edit: take a look at this screencast:
http://screencast.com/t/GanJybv4bF0

[CharlesParker]

Re: Date Range on Report

I'm pretty sure the date data field needs to be the time format too

[Reyesii]

Re: Date Range on Report

Gandhi

Thank you for your reply to my post. Your attached video was very educational.

Instead of using the greater then AND less than I used between(). Using Field names and Arguments.
Field Name = Date Closed
Arguments: Start_Date and End_Date

between(Date_Closed,:Start_Date,:End_Date)
I also used the data type, Date and Style type, Calendar.
This helped me just use a date from a calendar and not worry about how to format the date.


Is there an advantage to using Greater and Less then or is using Between() the same thing?