zjubias,
I expect it is just a missing comma.
=DateAdd("yyyy",1,[EffDate])+1
With a question like this, you should be providing us with the business rule like "the expiry date is one year plus one day from the EffDate".
Duane Hookom MVP
MS Access
----------------------------------------
> From: zjubias@gmail.com
>
> Hello All,
>
> Could someone help me please,
>
>
>
> What is the missing part of the below expression? I want to calculate the
> expiry date from my EffectiveDate (EffDate). I got invalid syntax error. Am
> placing the expression into the control source of my textbox "ExpiryDate".
>
>
>
> =DateAdd("yyyy",1[EffDate])+1
>
>
>
> Thank you,
>
> zjubias
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (13) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar