Hello,
I need to query a table that uses long dates (ex; 01/01/2012 00:00:00) and when I query from Jet it does not work. How do I convert or work with these dates in JET, the report hinges off of the date criteria.
I am looking for all records between "010112..123112", any help appreciated!
Kofseattle
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi!
When you say "long dates" I assume you are talking about DateTime type fields in NAV? Let me know if this is not the case. I tested this scenario with a DateTime field and doing something like this seems to work fine for me:
..1/1/2008 01:00 PM
Actually, as long as I didn't care about the time, just specifying the date itself worked ok for me as well like this:
..1/2/2008
It may depend on the date format in the regional settings on your machine, but this works for me. Does it not work for you?
Regards,
Hughes
Please sign in to leave a comment.