Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / November 2006

Tip: Looking for answers? Try searching our database.

Date conversion -- what date is B04FC6954E6BC501D9?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David Moss - 06 Nov 2006 00:20 GMT
Please see post on internet shortcuts for background, 11/3/2006 10:10 AM PST.

New problem.
Internet shortcuts have a modified date, as well as a date created and a
date accessed. I need to be able to retrieve the modified date. I am assuming
that that is what is stored in the .URL file with key "Modified=".

E.g., in the example in Doug Steele's article:
[DEFAULT]
BASEURL=http://www.smartaccessnewsletter.com/ME2/Audiences/Default.asp
[InternetShortcut]
URL=http://www.smartaccessnewsletter.com/ME2/Audiences/Default.asp
Modified=B04FC6954E6BC501D9
the modified date is B04FC6954E6BC501D9 (to repeat, I am assuming).

It's hex -- I can see that. It's 18 characters, or nine pairs -- I can see
that. But how, please, do I convert it into a date?

In case you're interested in the reason, the internet shortcuts are the 947
(as it turns out, thanks to Doug Steele's program) references I have
available to cite in some research I have been doing for the best part of
four years. URLs change over the years and it is good practice to quote the
date you accessed the web page. Normally, the date created would do. But I
seem to have had to re-construct my Favorites folder on 2 Feb 2005, because
that is the earliest date created I've got. The date modifieds go back much
earlier. As an example, I think 908B79DFA411C401ED should translate into 24
March 2004 13:35. But how?
Douglas J. Steele - 06 Nov 2006 16:10 GMT
Take a look at http://www.cyanwerks.com/file-format-url.html

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Please see post on internet shortcuts for background, 11/3/2006 10:10 AM
> PST.
[quoted text clipped - 30 lines]
> 24
> March 2004 13:35. But how?
David Moss - 07 Nov 2006 09:16 GMT
Blimey, what a way to represent a date/time! So devious! The exposed result
of some deeply hidden weird design decision taken 20 years ago? Anyway, thank
you again. Saved bacon you have my again once.

> Take a look at http://www.cyanwerks.com/file-format-url.html
>
[quoted text clipped - 32 lines]
> > 24
> > March 2004 13:35. But how?
Douglas J. Steele - 07 Nov 2006 12:14 GMT
What's so unusual about storing dates as the number of 100 nano-second
blocks since January 1, 1601? (and they had to tweak how they stored the
numbers so that it wouldn't be obvious to anyone when you last went to those
sites: that would be an invasion of privacy...) <g>

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Blimey, what a way to represent a date/time! So devious! The exposed
> result
[quoted text clipped - 44 lines]
>> > 24
>> > March 2004 13:35. But how?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.