[AccessD] Import Excel Dates into Access

Thank you so much Stuart.  You are absolutely right.  Even a right click
'filter by selection' will not result in matches for the same date because
of the time differences.  I've never used Int() with dates before and could
not find an example in MSDN.  Can you provide an example syntax?

TIA,

Mark


-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg] 
Sent: Tuesday, October 14, 2003 5:41 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Import Excel Dates into Access


On 14 Oct 2003 at 16:25, Mitsules, Mark wrote:

> Oleg_123,
> 
> Thanks for the reply.  I went ahead and implemented your 
> suggestion...setting the destination field format to Short Date.  When 
> the format is set to General Date the previous records do not have a 
> time component.  Does the "Short Date" approach have any negative 
> implications? Could it cause any impact to date calculations used in 
> criteria?  I hope not...
> 


The display format doesn't have any effect on the underlying data so 
won't affect date calculations. 

It can however mislead you into making errors in you criteria.

If you are displaying Date/Time records just as a date, you may be 
fooled into thinking that they only contain date info.  If the 
underlying data is "15 Oct 2003 07:30",  you will not get a match if 
you filter for Date = "15 Oct 2003"

If you only want the date part, you should strip off any fractional 
(time)  part when importing the data using Int() 

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.



_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com