Hello Duane,
Yes, pros really have a good eye..
Thanks a lot Sir,
zjubias
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Saturday, May 18, 2013 9:16 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Expiry - DateAdd - Need Help
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
[Non-text portions of this message have been removed]
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (14) |
Tidak ada komentar:
Posting Komentar