If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Date Str into Date (Urgent)
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Date Str into Date (Urgent)
On Tue, 20 Feb 2007 21:54:08 -0800, Trever B wrote:
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 Format("38833","mm/dd/yyyy") 04/26/2006 CDate("38833") 4/26/2006 -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|