I created some new POS items yesterday. When I tried to extract the new items for my QB interface I did not get any records. When running a qry agains the Item table I found that the creation date for all new items was set to 2004-04-02 14:52:07.000.
Not only is the date wrong but the time did not change either. However the last updated date shows the correct date and time.
My problem is that I need to filter on the creation date as I only want to extract the newly created items.
Anybody has an idea why I have the wrong creation date? The system date of the PC (XP SP2) shows the correct date and time.