Date Str into Date (Urgent)
the CDate() function will convert 38833 to 4/26/2006. if that's the correct
date, you're good to go. but i'm wondering if the date values show up as
recognizable dates in the text file. if so, are you importing the data by
using the Import Wizard? and if so, did you click on the Advanced button in
the wizard, and set up the date parameters so the values will import
correctly? those parameters a
DateOrder
DateDelimiter
TimeDelimiter (it won't apply if your date values don't include time values)
FourDigitYears
LeadingZerosInDates
hth
"Trever B" wrote in message
...
Hi,
Have imported a file as text and have a field call From_Date and has come
in
as text as 38833 what function do I use in access to change it to an
access
date
Thanks
Trev
|