DataBand Filter on DateTime object
-
jay@bplogix.com
- Posts: 251
- Joined: Fri Feb 04, 2011 11:46 am
- Location: San Diego, CA
DataBand Filter on DateTime object
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.
- Attachments
-
- 1384.pic2.png (43.85 KiB) Viewed 1691 times
-
- 1383.pic1.png (19.9 KiB) Viewed 1694 times
DataBand Filter on DateTime object
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.
[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.
-
jay@bplogix.com
- Posts: 251
- Joined: Fri Feb 04, 2011 11:46 am
- Location: San Diego, CA
DataBand Filter on DateTime object
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
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.
[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.