[AccessD] OT - Excel Date Formatting

Chris,

Thanks for your offer.  Yes that does change the appearance but M$ seems to
know better than I when it comes to importing the underlying data into
Access and will keep the time data during an import.  I have no use for the
time data.  My method works but seems "clunky".


Mar


-----Original Message-----
From: Foote, Chris [mailto:Chris.Foote at uk.thalesgroup.com] 
Sent: Monday, June 14, 2004 9:25 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] OT - Excel Date Formatting


Hi Mark!

Can you not just change the formatting of the column from mm/dd/yyyy h:mm:ss
to mm/dd/yyyy in the format cells dialogue?

If this is not quite what you want reply to me as I've got a hand-rolled
function to convert Excel dates/times to text.

Regards
Chris Foote - UK

> -----Original Message-----
> From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com]
> Sent: Monday, June 14, 2004 2:16 PM
> To: '[AccessD]'
> Subject: [AccessD] OT - Excel Date Formatting
> 
> 
> Group,
> 
> What is the simplest way to transform a column of dates...?
> 
> >From this: 5/3/2004  2:41:33 PM
> To this: 5/3/2004
> 
> Currently I'm using =MONTH(D2)&"/"&DAY(D2)&"/"&YEAR(D2), then 
> copying and
> using Paste Special (Values) to get the desired result.  Is 
> there a better
> way?
> 
> Thanks,
> 
> Mark
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com