Date conversion -- what date is B04FC6954E6BC501D9?

[Guest]

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]

Take a look at http://www.cyanwerks.com/file-format-url.html

 

[Guest]

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

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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]

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>

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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?