Toad World® Forums

Exporting SQLNAV to Excel has DATE format issue and shows 1/17/2018 12:00:00 A1P1 instead of 1/17/2018 12:00:00 AM


(I’m new and tried to locate a post on this before posting, but didn’t see any… sorry if this is a duplicate)

Exporting SQLNAV to Excel has bad DATE format

Format is “m/d/yyyy h:mm:ss \AmPm” but should be “m/d/yyyy h:mm:ss AM/PM” result is a value like “1/17/2018 12:00:00 AM” appears as “1/17/2018 12:00:00 A1P1”

I found mention of this on another forum where a competing product to SQL NAV also had the same problem, but I can’t find any mention for SQL NAV.




I am having the same issue.