incomplete file dates

[shakespeare5677]

I found a very strange problem in a gigantic program that I have no time to analyze closely just yet. The problem lies in file dates created and modified retrieved via a file object. They are retrieved as date objects, put into date objects and saved into access as date objects (..., #" & dtCreated & "#, #" & dtModified & "#,...). The trick is that they are occasionally saved as only dates with out the time which is very important. My code does not change or format anything, so not wishing to kill any time on it, I was hoping someone may have a quick explanation. Thanks.

-Max

 

[gmmastros]

Date fields always include a time component. If the time happens to be midnight, the display of the date/time value usually shows the date only.

Could it be that your problem (seeing the time) occurs when the time is 12:00 AM (midnight)?


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[shakespeare5677]

George, thanks for the quick reply. That's exactly what I thought so I checked the files. The files coming do all have time components, except that all the troublesome files (at least those that I saw) are 1am, not midnight. Although that does seem strange for files that have been created/downloaded/unzipped at all different times, they all have 1am, but the dates are appropriate.

-Max

 

[macleod1021]

With the "occasionally" statement, that leads me to go with mastros. If that's not the case, then you need to run some test data through the app to see when it does happen. Until the problem can be isolated as to the exact reason, it's a goose hunt.

 

[shakespeare5677]

macleod1021: I completely agree, except that I am extremely confident in that the code does not alter or format the dates as they are saved, and so I was trying to see if anyone has encountered similar problems before I approach the boss with the problem.

-Max