I was wondering if theres any way to add your own date depending on the period. We use a period choice field that defines specific days.
Is there any way to make it that once you switch to the 3rd period, the date below would change to Jan 27, 2018 and if it was the 4th period, it would change to Feb 28, 2018?
You could allocate specific dates to a period and use a nested if / else statement.
Date := if Period = 3 then "Jan 27, 2018" else if Period = 4 then "Feb 28, 2018" else ""
You can put the trigger on the Period field.
Let me know if this goes into the right direction.
Thank you alex, it works great!