Search:

Hi Dilettante,

Actually, you can go less than one. It just starts counting the days backwards from 12/30/1899.

Take Care,
Elroy



debug.Print format$(-5, "mm/dd/yyyy") ' <--- prints:...

Hi IkkeEnGij,

I'm not sure what you're trying to say there, but maybe try the following code:



Dim D As Date
For D = #12/28/1899# To #1/1/1900# Step 0.125
Debug.Print...

Now that's a bit of a fun problem, and I'll accept that as a challenge. Also, I'm going to do it without using any of the built-in date functions, as they'd just make it more complex.

Building on...

Hey Techgnome,

Just wondering what you mean by the bolded part of what I've quoted. A Date is truly just a special case of a Double where 0 = #12/30/1899 00:00:00#
The integer part is a count of...

@Chris: So long as myData() is declared as a Date, nothing is going to go into it that "remembers" any formatting.

@DataMiser: Yes, I like the way you said that.

Hi Daniel,

Any variable declared as "Date" (array or not) knows nothing about any formatting. It's just a special case of an IEEE Double. It's only when you print (or otherwise show) the date...