A
Amy Urian
We have two date fields, one (date1) is for the initial due date (user
defined), and the other (date2)is the second due date which is one year
later. Date2 automatically generates from Date1 by setting the Initial
Value to (Format([Date1] + 365 , "mm/dd/yyyy" )). The problem is that if
Date1 is empty, Date2 displays "1/1/1601". I have tried many if
statements and none have worked.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
defined), and the other (date2)is the second due date which is one year
later. Date2 automatically generates from Date1 by setting the Initial
Value to (Format([Date1] + 365 , "mm/dd/yyyy" )). The problem is that if
Date1 is empty, Date2 displays "1/1/1601". I have tried many if
statements and none have worked.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!