Date Str into Date (Urgent)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 are:

DateOrder
DateDelimiter
TimeDelimiter (it won't apply if your date values don't include time values)
FourDigitYears
LeadingZerosInDates

hth
 
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
Click to expand...

Format("38833","mm/dd/yyyy")
04/26/2006

CDate("38833")
4/26/2006
 
Back
Top