A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Date Str into Date (Urgent)



 
 
Thread Tools Display Modes
  #1  
Old February 21st, 2007, 06:54 AM posted to microsoft.public.access.queries
Trever B
external usenet poster
 
Posts: 16
Default 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  
Old February 21st, 2007, 07:37 AM posted to microsoft.public.access.queries
tina
external usenet poster
 
Posts: 1,997
Default 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  
Old February 21st, 2007, 07:41 AM posted to microsoft.public.access.queries
fredg
external usenet poster
 
Posts: 4,386
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:04 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.