creating autodate fields

[Anthony]

Hi,
Another quick question.
I want to add a New date field on a form'
have it recognise another date field and add 90 days to it,
then reflect that date in the New field I added.
Not sure how in access.

Thanks,
Anthony

 

[losmac]

For the New Field enter in DefaulValue like this:
= DateAdd("d";90;[AAA].[DateOld])
where DateOld is a field with your another date
(recognised field).

Read more about Date functions in help files.

losmac

 

[Cheryl Fischer]

= DateAdd("d";90;[AAA].[DateOld])

Shouldn't that expression use commas rather than semi-colons?

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

For the New Field enter in DefaulValue like this:
= DateAdd("d";90;[AAA].[DateOld])
where DateOld is a field with your another date
(recognised field).

Read more about Date functions in help files.

losmac

-----Original Message-----
Hi,
Another quick question.
I want to add a New date field on a form'
have it recognise another date field and add 90 days to it,
then reflect that date in the New field I added.
Not sure how in access.

Thanks,
Anthony
.

 

[Douglas J. Steele]

Depends what the Regional Settings are.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

= DateAdd("d";90;[AAA].[DateOld])

Shouldn't that expression use commas rather than semi-colons?

--
Cheryl Fischer
Law/Sys Associates
Houston, TX

For the New Field enter in DefaulValue like this:
= DateAdd("d";90;[AAA].[DateOld])
where DateOld is a field with your another date
(recognised field).

Read more about Date functions in help files.

losmac

-----Original Message-----
Hi,
Another quick question.
I want to add a New date field on a form'
have it recognise another date field and add 90 days to it,
then reflect that date in the New field I added.
Not sure how in access.

Thanks,
Anthony
.