I have a table with dates of surveys; the next column adds 5 years to that date. the 3rd column compares the two dates. if the second column is less than todays date it will give a message if not it will insert the date from the 2nd column
ex.
A:survey date
B(Expr1):survey date + 5 years
C: if B < 2/6/2010 then "Turn in new Survey" if B>"2/6/2010" then "B"
Survey Message: IIf(([Expr1])<"2/6/2010","PAST DUE, PLEASE SUMBIT A NEW SURVEY WITH PICTURES BY Feb. 6, 2012",[Expr1])
value of Ex.
A:3/5/2001
B:3/5/2006
C:Turn in new Survey
Great! this works fine
But:
A:12/12/2008
B: 12/12/2013
C:s/b 2/12/2013 *
*but it compares the 1 (12-December) with 2 and it thinks it's smaller and it puts the message! how do I compare values or the whole date?