Need help displaying the current year and quarter in a label control using Nintex Forms.
I have a calculated value column in the list with a default value formula that displays the correct year and quarter, but when using this field in the Nintex Form it doesn't calculate and display the value at form load.
Calculated Value Formula (using Modified date field):
=ASC(YEAR([Modified]))&"-"&IF(MONTH([Modified])<4,"Q1",IF(MONTH([Modified])<7,"Q2",IF(MONTH([Modified])<10,"Q3","Q4")))
Anyone that can help with a formula I can use in the Insert Reference section, or another alternative solution to this requirement, would be greatly appreciated.
Thanks!