HI,
I have a custom report into GP, this report can export to excel, the report is a inventory kardex, and show all the inventory transaction in a period time, today when I generate te report with 4th July, in Excel the dates appears like 02/01/1900, when check the information in the table by SQL all the records have empty date, they are like 01/01/1900...
Can be this a problem from some update in Office? now in July?
If the query itself is returning a blank date, what query is being ran to get the data? Once we know where the data is coming from in the query, you can then review the transaction which set the data to see if we potentially have a cause.
Once you see what table the data i pulled from and review the transaction, in a test company try to recreate the transaction and see if the same issue occures.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,554
Super User 2024 Season 2
#2
Martin Dráb
228,588
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
