Good afternoon. I am creating a report that I want to filter at the query stage so it only selects those whose discharge date and time is less than or equal to a certain (prompted) date. The problem that I can see is that the calendar will only show the date. So I can't use "Less than or equal to" from the drop-down list as it appears to exclude, for example, 30th June 2015 15:30.
I have got round this issue by setting the end date as less than the first of the following month, which works, but that doesn't quite seem right.
Any thoughts please?
Many thanks,
D€$
I have got round this issue by setting the end date as less than the first of the following month, which works, but that doesn't quite seem right.
Any thoughts please?
Many thanks,
D€$