Re: Adding Days to a Date
- From: "Duane Hookom" <duanehookom@xxxxxxxxxxxxxxxxx>
- Date: Thu, 10 Nov 2005 16:11:37 -0600
Try
CDate(Left$([date],2) & "/" & Mid$([date],3,2) & "/" & Right$([date],2)) +
10 as grcExpDate
--
Duane Hookom
MS Access MVP
--
"tim" <hawk88gt@xxxxxxxxx> wrote in message
news:Ncmdna46WuO_Xu7eRVn-ow@xxxxxxxxxxxx
>I get a text file and link it to a Access table. I then transfer it to
> another table with a text field that is a date and data is in this format:
> 091105. I run a query to add forward slashes:
>
>
>
> Left$([date],2) & "/" & Mid$([date],3,2) & "/" & Right$([date],2)
>
>
>
> The problem is I need to add 10 days to this date to be used in a merge
> document. The only way I am able to do this is to change the field type to
> date/time after I transfer the data and run the above-mentioned query. I
> have tried changing the field type to date/time before the transfer and it
> does not work. Below is part of the query I use to add 10 days to the
> date.
>
>
>
> [date]+10 AS grcExpDate
>
>
>
> What am I doing wrong?
>
> Any help would appreciated.
>
>
>
> Tim
>
> Access 2000
>
>
.
- References:
- Adding Days to a Date
- From: tim
- Adding Days to a Date
- Prev by Date: Re: Adding Days to a Date
- Next by Date: Re: Must I create a record for each value in a field in this table?
- Previous by thread: Re: Adding Days to a Date
- Next by thread: Re: Syntax on Create Table...
- Index(es):
Relevant Pages
|
