[AccessD] Expiration Date

I was going to suggest a function as well (thats what I would have
done as well).

I actually sent her an example using conditional formatting as I
thought she was using continuous forms at first.

On Wed, Oct 28, 2009 at 9:20 AM, Arthur Fuller <fuller.artful at gmail.com> wrote:
> With all respect to David, I would create a function and call it from
> OnCurrent rather than embed the logic therein. Different strokes for
> different folks, I guess. My approach is always to isolate functionality,
> not least because I might need to call the same code from somewhere else in
> the app.
>
> A.
>
> On Tue, Oct 27, 2009 at 1:23 PM, David McAfee <davidmcafee at gmail.com> wrote:
>
>> I'd keep it in the OnCurrent event.
>>
>> Use NZ() and some future date
>>
>>  'DateEarlyExp.value =  DateDiff('d',Date(),NZ([DateEarlyExp],DATE()+365))
>>
>>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>