Date format changing

[eti3nne]

(1)When I extract the fileinfo (by code) from a set of files in a directory, the date format on the extracted list changes from dd/mm/yyyy (as shown in explorer) to mm/dd/yyyy when I write the fileinfo data into my spreadsheet.

(2)'Date accessed' is only ever shown as a date plus 12:00, even in Explorer., whereas 'created date' and 'modified date' show as date+actual time. Perhaps this has always been so, i've just never noticed before?

PS. My PC and Office products are both set to UK style dates as far as I know.

Any ideas?
Thanks for looking.

 

[SkipVought]

Hi,

faq68-5827

What application? I'm assuming Excel.

I woud NEVER open a text file, like a .csv, directly. You will get unreliable results as Excel makes some "helpful" (or NOT) assumptions about dates, sime Bill Gates is in Washington, USA.

Rather IMPORT text files, using the Data > Import External Date... feature. In this process, you can EXPLICITLY parse any date column exactly as you desire.

As you see, in the FAQ, date formatting changes nothing, except what is displayed.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}