[AccessD] Problem with Date type variable

Barbara,
 
Just ignore the time portion until you are ready to print the report.
There is nothing you can do about deleting the time portion from the
Date datatype since it is really a DateTime datatype.  On the report you
will want to format dtDate so as to not show any time.
 
 

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: Barbara Ryan [mailto:BarbaraRyan at cox.net] 
Sent: Tuesday 2003 Mar 25 08:02
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Problem with Date type variable


I am importing data from a text file ---- only if the "date" in this
import file is populated (i.e., NOT blank/spaces), then the import date
is moved to my date variable ("dtDate").  I then write the contents of
dtDate (along with other data) to a table, which is then printed on a
report.  Should I be checking "If dtDate <> 12:00:00 AM, then write
contents of dtDate to table date?"
 
Thanks,
Barb

	----- Original Message ----- 
	From: Jim DeMarco <mailto:Jdemarco at hshhp.org>  
	To: accessd at databaseadvisors.com 
	Sent: Tuesday, March 25, 2003 8:33 AM
	Subject: RE: [AccessD] Problem with Date type variable

	That's the zero value for a Date datatype.  Any variable of this
type has this value until you fill it with a value.

	Thanks, 

	Jim DeMarco 

		-----Original Message-----
		From: Barbara Ryan [mailto:BarbaraRyan at cox.net]
		Sent: Tuesday, 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/464d3b7b/attachment-0001.html>