Hi,
This is really annoying me as it seems to be a very simple filter but I can't get it working correctly!
I have some code that produces a text string filter for a report depending aon what users enter for filter conditions on various fields on a form. All works fine except the date filtering. The following is an example of the most basic date filtering string that the form can produce:
[Completion Date] between #01/07/2007# AND #31/07/2007#
The report takes notice of the final date value in the string but totally ignores the first and would for example list all records with date up to 31/07/2007. ie it will include all those before 01/07/2007 as well.
I can vary the date range and it happily takes notice of the end date in the range but never the start date.
Any ideas as to why this happening?
Thanks in advance for any help.
John
This is really annoying me as it seems to be a very simple filter but I can't get it working correctly!
I have some code that produces a text string filter for a report depending aon what users enter for filter conditions on various fields on a form. All works fine except the date filtering. The following is an example of the most basic date filtering string that the form can produce:
[Completion Date] between #01/07/2007# AND #31/07/2007#
The report takes notice of the final date value in the string but totally ignores the first and would for example list all records with date up to 31/07/2007. ie it will include all those before 01/07/2007 as well.
I can vary the date range and it happily takes notice of the end date in the range but never the start date.
Any ideas as to why this happening?
Thanks in advance for any help.
John