[AccessD] File Date Time

[William Benson]

Thank you.

On Jul 27, 2017 7:24 AM, "Stuart McLachlan" <stuart at lexacorp.com.pg> wrote:

> 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>