zjubias,
Did my suggested expression work or are you still looking for assistance?
Duane
----------------------------------------
> From: zjubias@gmail.com
>
> Duane,
>
> Sorry I left your last paragraph.
>
> With regards with business rule of our company, yes we are having 1 day plus
> as a grace period..
>
> Regards,
> zjubias
>
>
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
>
> 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 <mailto:zjubias%40gmail.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 (16) |
Tidak ada komentar:
Posting Komentar