+1I am trying to use the following to get difference of dates in Quarters and the formula will not resolve as function is not supported in the nintex forms.
=FLOOR(((YEAR([date2])*12+MONTH([date2]))-(YEAR([date1])*12+MONTH([date1])))/3,1)
This works in the Sharepoint List side but not on the Nintex form. Any guidance is appreciated.
Hi @catsmith
I assume you are using a Calculated Value control on a Nintex Form. I hope I am not over-simplifying this, but would the following formula not produce a similar result?
round((dateDiffDays(Date2,Date1)/91.25),1)
Also, you can reference supported runtime functions in Nintex Forms here:
+23The Floor Function always rounds down.
https://support.office.com/en-us/article/floor-function-5168a039-9501-4e02-ac52-83914290ac55
But the Nintex round function will round to the nearest whole number so the results could be different as it may round up.
Using nicksha's formula you could just snip off the decimals and keep the whole number which is the same as rounding down.
replace((dateDiffDays(date1,date2)/91.25),"([^0-9].[0-9]*)","")
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
