[AccessD] Problem with Date type variable

That's just a formatting issue. Copy the following into a module:
 
Public Sub TestDate()
    Dim d As Date
    Debug.Print d
    Debug.Print Format(d, "long date")
    
End Sub

In the debug window you will see:
 
12:00:00 AM 
December 30, 1899

HTH,
Arthur
 

"Those who would sacrifice liberty for security deserve neither."
-- Benjamin Franklin 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Barbara Ryan
Sent: March 25, 2003 7:52 AM
To: Access List
Subject: [AccessD] Problem with Date type variable


I am encountering a problem with date type variables in Access 97.  When I
create a date type variable (e.g., "Dim dtDate as Date") , the variable has
a default value of 12:00:00 AM.  I don't remember this happening before.
 
I recently did a "cleanup" on my PC, removing software I no longer use.
Could I have removed a needed driver(s)?  I ask that question because I am
also having a problem with my printer (HP IIP Plus) not printing lines on
reports (which it was doing fine last week).  
 
Any thoughts?
 
Thanks,
Barb Ryan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030325/dfe37f99/attachment-0001.html>