If you have a third statement, you need to be using a CASE statement, not an IF.
If ( something ; result ; or else this )
something 1 ; result 1 ;
something 2 ; result 2 ;
something 3 ; result 3 ;
or else this
I understand how to use If and Case statements.
What I don't understand is how to set up the logic using dates.
Current Date < Create Date + 30
Current Date < Create Date + 90
Current Date > Create Date +90
Get(CurrentDate) < (Create Date + 30) ; Result 1 ;
Get(CurrentDate) < (Create Date + 90) ; Result 2 ;
Get(CurrentDate) > (Create Date + 90) ; Result 3 ;
Thanks, that worked.
I didn't know I could just add a number to a date.
Tick to Mike's calc. Just a couple of additional thoughts:
1. What is the result = 30, or = 90? Consider whether you should be using the ≤ operator instead (less than or equal to).
2. With Case statements, remember FM will only evaluate the options until it finds a correct result; then it will ignore the rest. So the order of the options is important (if you had < 90 before < 30, the latter would not be evaluated).
You gave yourself credit for the correct answer. You probably meant to credit Mr. Beargie.