Hundred Year Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone know how to convert a date to the hundred year date format.
For example, how would i convert 8/11/2004 to its hundred year date format.
Thanks!

Tim
 
I'm not familiar with the "hundred year date format", What would the end format look like for '8/11/2004' ?
 
Does anyone know how to convert a date to the hundred year date
format. For example, how would i convert 8/11/2004 to its hundred year
date format. Thanks!
Click to expand...


You can use the FormatDateTime or Format function.
 
Does anyone know how to convert a date to the hundred year date format.
For example, how would i convert 8/11/2004 to its hundred year date
Click to expand...
format.

"Hundred year format"??? What on earth is that?
 
I do believe this is what you are after

Dim dt As DateTime = #8/11/2004#
Dim d As Long
d = dt.ToOADate
 
I'm just curious, but does anybody know how 8/11/2004 becomes 38209? What's the basis of this hundred year format?

Chris
--------------------
 
Chris said:
I'm just curious, but does anybody know how 8/11/2004 becomes 38209? What's the basis of this hundred year format?
Click to expand...

It's the number of days since some point near the start of 1900.

See the docs for DateTime.ToOADate().

There may be a bit of discrepancy - the OP said that 8/11/2004 should be
38209.

ToOADate() returns 38210 for that date.
 
Back
Top