p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

vba_access thread: Using datediff(validation rule)in access?


Message #1 by Hafiza Abd Rahim <babybrutal99@y...> on Mon, 23 Jul 2001 19:02:47 -0700 (PDT)
Use DateAdd

Ddue=DateAdd("d",7,Ddate)

John Ruff - The Eternal Optimist :)
-----Original Message-----
From: Hafiza Abd Rahim [mailto:babybrutal99@y...]
Sent: Monday, July 23, 2001 7:03 PM
To: VBA_Access
Subject: [vba_access] Using datediff(validation rule)in access?

hi all..
I want to know..how to use datediff(validation rule)
in access?
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
vb..
while DDue function to list a due date after Ddate - 7
days..
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....

  Return to Index