creating autodate fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthony - 14 Nov 2003 15:32 GMT

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

Reply to this Message

losmac - 15 Nov 2003 13:56 GMT

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,
[quoted text clipped - 7 lines]
>Anthony
>.

Reply to this Message

Cheryl Fischer - 16 Nov 2003 20:32 GMT

> = 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])
[quoted text clipped - 17 lines]
> >Anthony
> >.

Reply to this Message

Douglas J. Steele - 16 Nov 2003 21:15 GMT

Depends what the Regional Settings are.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

> > = DateAdd("d";90;[AAA].[DateOld])
>
[quoted text clipped - 26 lines]
> > >Anthony
> > >.

Reply to this Message