I am saving this in Calculated valve back into the table
[LastTestDate]+364
I dont know how to proceed with calculating the next date with condition mentioned in my first post. Is it a good idea to perform in form? if so how?
Apu91
Last Activity: Dec 15 '15, 04:01 PM
Joined: Dec 15 '15
Location:
-
calculate the next date with a condition based on another field in the table
I have a field "x" with data : "3 and 4" for respective customers
I want the next date to be calculated for 1 year if the customer with x field is 4 and calculate 2 years if the field"x" is 3.
Right now to just calculate all the date with interbval of 1 year i have entered as
[LastTestDate]+364 but it calculates 1 year for all and does not satisfy the condition for customer with field x as...
No activity results to display
Leave a comment: