Good morning!
I think I know the answer to this, although I'm hoping I'm wrong!
I have a form where users can enter dates based on a test sample. There are 5 samples at most taken, and eventually one of those samples will pass the test. Each date also has a check box which records a yes or no in the table - this works just fine.
What I want to do is then calculate the "days to pass" for this test by writing language that looks at the date that the test passes and does a simple date diff calculation.
I cannot for the life of me make this work. I can make it display the days to pass on the form, but I need it to record it in the table as well.
Thoughts?