How can I calculate in Nintex workflow the first day of the next quarter? Thanks!
+4
Igor,
If you have access to SQL, it could be a simple query to SQL, using Execute SQL action, something like
SELECT DATEADD(QQ, DATEDIFF(QQ, 0, DATEADD(QQ, 1, @CurrentDate)),0). You would replace the CurrentDate parameter with the current date from the workflow.
+9
I ended up using a calculated formula and it seems to be working. I wanted to default a date field on a form to it.
=DATE(YEAR([Today])+(MONTH([Today])>9),CHOOSE(MONTH([Today]),4,4,4,7,7,7,10,10,10,1,1,1),1)
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.