Page 1 of 1
DataBand Filter on DateTime object
Posted: Tue Oct 25, 2011 7:23 pm
by jay@bplogix.com
I am trying to use a filter set to the Value of a DateTime object set to a specific date. But it filters out all rows. Since it is a DateTime object, there is a time value as well. But the GUI only shows a date picker. I really want this filter to return all rows where the Date portion of the DateTime is equal to the date picker. But it does not seem to work.
DataBand Filter on DateTime object
Posted: Wed Oct 26, 2011 3:05 am
by HighAley
Hello.
[quote="jay"@bplogix.com]I am trying to use a filter set to the Value of a DateTime object set to a specific date. But it filters out all rows. Since it is a DateTime object, there is a time value as well. But the GUI only shows a date picker. I really want this filter to return all rows where the Date portion of the DateTime is equal to the date picker. But it does not seem to work.[/quote]
There is a problem because the time differs from 00:00:00.
Please, try to use between '16.11.2009' and '17.11.2009' condition instead of "equal to".
Thank you.
DataBand Filter on DateTime object
Posted: Wed Oct 26, 2011 1:11 pm
by jay@bplogix.com
If you are only prompting for the date ... shouldnt it only compare the date? It seems difficult for report creators to use "between '16.11.2009' and '17.11.2009'" when they want to filter rows by a certain date.
DataBand Filter on DateTime object
Posted: Thu Oct 27, 2011 7:04 am
by HighAley
Hello.
[quote="jay"@bplogix.com]If you are only prompting for the date ... shouldnt it only compare the date? It seems difficult for report creators to use "between '16.11.2009' and '17.11.2009'" when they want to filter rows by a certain date.[/quote]
We are working on the problem. We will let you know when the solution is available.
Thank you.