[AccessD] File Date Time

[Dan Waters]

In the folder that holds these picture files, on the top row of column headers, right-click on Date Modified and select Date Created.  Check to see if those dates are different to begin with.  If not then getting that date in code won’t help anyway.

IIRC there is something about Create Date of a file that causes it to change when you’d expect that it wouldn’t.

Dan

Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10

From: Rocky Smolin<mailto:rockysmolin at bchacc.com>
Sent: Wednesday, July 26, 2017 13:07
To: 'Access Developers discussion and problem solving'<mailto:accessd at databaseadvisors.com>; 'Off Topic'<mailto:dba-ot at databaseadvisors.com>
Subject: [AccessD] File Date Time

Dear List:



Still working with renaming a folder full of pictures.  As Stuart suggested
I'm creating a table of photos I the folder with names and date.  But I'm
using



  strFileName = Dir$(strFolder & strFileSpec)

  While strFileName <> ""

       rs.AddNew

       rs!fldPhotosFileName = strFileName

       rs!fldPhotosFileDate = FileDateTime(strFolder & strFileName)

       rs.Update

       lngCount = lngCount + 1

      strFileName = Dir$

  Wend

  rs.Close

  Set rs = Nothing



but FileDateTime as described in the msdn page is the tie the file was
created or last modified.  I need the creation date as some of them have
been modified but I need to rename them in create date sequence.



Is there a way to get just Create Date?



MTIA



Rocky



--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com