[AccessD] File Date Time

[Stuart McLachlan]

Yes. It's part of the EXIF data which is written into the image file by the camera when it is 
created.    The only way that can be changed is with an EXF editing tool 

If you've got a photo on your computer that have been taken with a modern digital camera or 
a smartphone,right click on it and select Properties - Details.  You will see just how much 
data is stored about a photo.  One item is "Date Taken"

By clicking on a data item, you can edit it there, but Windows won't do that by itself.


On 27 Jul 2017 at 3:24, Bill Benson wrote:

> Does this date get retained when making a round trip to the cloud? I
> have found many of my image archives screwed with through this
> process.
> 
> On Wed, Jul 26, 2017 at 3:03 PM, Rocky Smolin <rockysmolin at bchacc.com>
> wrote:
> 
> > Well I found the solution in file system object. The 12th property
> > is the date the picture was taken, not the date it was created in
> > the folder.  So then I had to manipulate that because of the
> > unprintable characters in it.
> >
> > Any short story long, I've got the pictures in chronological
> > sequence of date TAKEN and renamed them all with a sequence number
> > so that the file names sort in date picture TAKEN.
> >
> > And I have a brand new skill I'll probably never use again. :)
> >
> > R
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On
> > Behalf Of Dan Waters Sent: Wednesday, July 26, 2017 11:22 AM To:
> > Access Developers discussion and problem solving Subject: Re:
> > [AccessD] File Date Time
> >
> > 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
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>