Got it...you hit the nail on the head with null value.:~/
Date_A had null value - so I changed this to @Today - it's just a matter of refreshing fields if I change date in Date_A.
Thanks for you help.
Ian [thumbsup2]
Hi,
Date_A field is Type: Date/Time, editable.
Date_B field is also Date/Time - I have tried computed and editable.
Date_A field is filled in with any date (ie when a test was taken). I want Date_B field to be 3 years ahead (ie when the test is due for re-testing). So if Date_A field was...
Hi all,
I have a field 'Date_B'(a time/date field) with the following formula:
@Adjust(Date_A;3;0;0;0;0;0)
It takes the date from Date_A field and increments the year.
I have no compile problems. However when I come to test the form I get the error:
Field:Date_B: incorrect data type for...
Hi,
This is my first post and I have a question for you. I hope I can explain this well enough:
In a form I have a list box which populates a field using @dbcolumn lookup. In this case it's the document title in another database...no problem.
What I want to be able to do is after this field...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.