I have something strange going on here.
My client's regional setting are month-day-year.
When I go into NAV, the dates are displayed as month-day-year.
But when i run a jet report, the dates show up as day-month-year.
Any idea why ?
Client is on SQL 2008, NAV 6.0 SP1 Classic Client.
Date
Votes
1 comment
-
Jet Reports Historic Posts Normally, when you pull a date into Excel using Jet Reports it will show up in the Julian format, such as "43214" or "41225", etc.
Most of the time the user will format the cell to be in the format that they want. Can you right click on the cell in Excel, click on the Format Cell button, and look at the formatting in Excel? While you are in the "Format Cell" window, click on the Date category. On the right you will see different date formats and at the bottom you will see "Locale (Location)". This is the Windows setting that Excel is using. You may need to look into the regional settings or just manually format the dates in Excel.
Please sign in to leave a comment.