I have a table with a datetime field on which I would like to filter with a date value.
Is there a way to do this with the NL function without counting an extra day to the end date?
Thanks in advance for any help.
Date
Votes
5 comments
-
Jet Reports Historic Posts Official comment It could be that "C" is not the indication for a closing date in your language. In my case - I'm Dutch - I'd have to use a "U" (short for Ultimo) instead of "C".
If you don't know the letter in your language, ask your accounting department please. They use it when they close a fiscal year. -
Jet Reports Historic Posts Do you mean to do something like a start date with no end date?
For instance, filtering on invoices for the entire week to date - I think the date filter in your query would be: 05/26/14..
Quite honestly, I have not tested such a filter, and currently I have Jet tied up with another project and can't verify that it would work.
I have tested this the other way (no beginning date), and it works this way: ..05/26/14
if this doesn't help, please let us know!
~ Heather -
Jet Reports Historic Posts Hi Heather, thanks for your reply. I guess I did not explain it well.
So I will try again.
06/01/2014 10:00
06/02/2014 19:00
06/03/2014 23:00
06/04/2014 07:00
When I want to filter on the first 3 dates, I have to filter like 06/01/2014..06/04/2014 or >06/01/2014&<06/04/2014.
When I should type 06/01/2014..06/03/2014 I only get the first two dates because a date without time will be translated to MM/DD/YYYY 00:00.
To make it more simple for the users I was wondering if there is a way to convert the datetime field to a date only field for easier filtering.
I hope this is more clear. -
Jet Reports Historic Posts Hi Erik,
It's been a while since I filtered a datetime field. Let me see if this helps… add the closing date symbol to the date filter e.g. "6/1/2014..C6/3/2014"
A closing date is stored like d/m/yyyy 23:59:59 so that should give you the same result as your ">6/1/2014&<6/4/2014" filter.
Let us know if it works, ok? -
Jet Reports Historic Posts Hi Hans, thanks for your reply. When I use a filter like "6/1/2014..C6/3/2014" then I get a message "C6/3/2014 is an invalid date".
Please sign in to leave a comment.