AnsweredAssumed Answered

How can I display the current Quarter and Year in a label?

Question asked by supermankelz on Oct 18, 2016
Latest reply on Jul 26, 2018 by ohagas

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!

Outcomes