It did work Duane, huh, it seems my first mail did not come to you..
It works, thanks a lot..
Definitely, I will be needing lots of assistance from the pros like you Sir.
Currently, am working with the db which I inherited, and since am not an
code savvy, I will be a regular student here..
zjubias
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Duane Hookom
Sent: Saturday, May 18, 2013 9:52 PM
To: Access Professionals Yahoo Group
Subject: RE: [MS_AccessPros] Expiry - DateAdd - Need Help
zjubias,
Did my suggested expression work or are you still looking for assistance?
Duane
----------------------------------------
> From: zjubias@gmail.com <mailto:zjubias%40gmail.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
<mailto:MS_Access_Professionals%40yahoogroups.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>
<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 (17) |
Tidak ada komentar:
Posting Komentar