Date filter issue, records not showing properly

This public forum is for user-to-user discussions of ASP Report Maker. Note that this is not support forum.

Date filter issue, records not showing properly

Postby monasa » Thu Nov 26, 2015 10:04 pm

I'm using SQL Server.
I have a column in a table, tt_reported_date which is DATETIME type.

There are 5 records in the table
2015-02-13 09:54:14.757
2015-02-17 10:56:21.727
2015-02-21 11:27:40.870
2015-02-28 11:48:42.933
2015-02-28 11:54:41.500

When I do extended filter using between <from date> and <to date>, in which I select the date from datepicker as 01/02/2015 and 28/02/2015, the report just showing 3 records
2015-02-13 09:54:14.757
2015-02-17 10:56:21.727
2015-02-21 11:27:40.870

instead of 5 records.

Any idea what have been missing here? Any workaround or alternative ways to get the desired output?
monasa
 
Posts: 4
Joined: Thu Nov 26, 2015 9:53 pm

Re: Date filter issue, records not showing properly

Postby motfs » Fri Nov 27, 2015 10:58 am

You write 28/02/2015 mean 28/02/2015 00:00:00 AM. In order to get the records, change the search date as 01/03/2015.
motfs
 
Posts: 710
Joined: Tue Sep 08, 2015 4:55 pm

Re: Date filter issue, records not showing properly

Postby monasa » Fri Nov 27, 2015 3:07 pm

motfs wrote:
> You write 28/02/2015 mean 28/02/2015 00:00:00 AM. In order to get the
> records, change the search date as 01/03/2015.

I'm looking around for the solutions not the recommendation on how to select the date. I'm pretty sure that if a user want to see the data for a month of Feb, he/she would select 1st to 28th of Feb not selecting the 1st March.
monasa
 
Posts: 4
Joined: Thu Nov 26, 2015 9:53 pm

Re: Date filter issue, records not showing properly

Postby motfs » Sat Nov 28, 2015 9:57 am

If you want to choose to filter for Month interval, you can simply select "Date Interval" as Month so user can select different month instead of inputting date. See Field Setup -> Date Interval in help file for more details.
motfs
 
Posts: 710
Joined: Tue Sep 08, 2015 4:55 pm

Re: Date filter issue, records not showing properly

Postby monasa » Wed Dec 02, 2015 9:07 pm

motfs wrote:
> If you want to choose to filter for Month interval, you can simply select "Date
> Interval" as Month so user can select different month instead of inputting date.
> See Field Setup -> Date Interval in help file for more details.
Thanks, it worked.
monasa
 
Posts: 4
Joined: Thu Nov 26, 2015 9:53 pm


Return to General Discussion (ASP Report Maker)