0

Date filter by dd/MMM/yyyy

Jet Reports Historic Posts

March 05, 2013 04:11

None

Follow

hi,
i have a customer who insists that she wants to keep her date regional settings in dd/MMM/yyyy.
However the reports I have done originally in dd/MM/yyyy failed to run for date filters with this new date format.
The error shows I have provided an invalid date format.


Please help.
ps. For this testing, i have changed my own date regional settings to dd/MMM/yyyy

AFON

• DateFilter Error.png

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Jet Reports Historic Posts March 05, 2013 06:49

  Are you sure the bracket is right after the first date filter (just before the first &)?
  
  Cheers
  André

• 0
  
  Jet Reports Historic Posts March 05, 2013 12:04

  Hi,
  
  I think the problem is not in your regional settings, jet should just work regardless of your date format.
  
  
  The formula I'm using here is:
  =NL("Rows","Job",,"Creation Date",F2&".."&G2)
  If you'd attach your report here, maybe I can help you further.
  
  Andy
• 0
  
  Jet Reports Historic Posts March 05, 2013 16:21

  Afon,
  
  It looks like NAV actually can't handle a short date format that has month names spelled out instead of in a numeric form. NAV itself is rejecting the date filter. I'm afraid your user is not going to be able to use that short date format with Jet/NAV.
  
  Regards,
  Hughes