How would I pre-populate a Single Value field on a Form with the text form for the current month? I know I can use =MONTH(TODAY()) to get the month as a number but I need it in long text form. I tried this:
=IF(MONTH(TODAY()) == 1, January, IF(MONTH(TODAY()) == 2, February, IF(MONTH(TODAY()) == 3, March, IF(MONTH(TODAY()) == 4, April, IF(MONTH(TODAY()) == 5, June, IF(MONTH(TODAY()) == 7, July, IF(MONTH(TODAY()) == 8, August, IF(MONTH(TODAY()) == 9, September, IF(MONTH(TODAY()) == 10, October, IF(MONTH(TODAY()) == 11, November, IF(MONTH(TODAY()) == 12, December)))))))))))
However I kept getting the Calculation Syntax Error for that textbox. Any suggestions?