John Ruff - The Eternal Optimist :)
From: Hafiza Abd Rahim [mailto:babybrutal99@y...]
Sent: Monday, July 23, 2001 7:03 PM
Subject: [vba_access] Using datediff(validation rule)in access?
I want to know..how to use datediff(validation rule)
let say i have 2 fields in 1 table..Field 1 is DDate
and field 2 is DDue..
DDate shows list of different date that we key in from
while DDue function to list a due date after Ddate - 7
I don't know how to code that formula..
Date in DDate field minus 7 days..and the new date
will list in DDue..
So how to code the formula and where to put it?
please somebody help me....