igorsp
Scout

First day of the next quarter?

Jump to solution

How can I calculate in Nintex workflow the first day of the next quarter? Thanks!

Reply
2 Replies
prasannaadavi
Novice

Re: First day of the next quarter?

Jump to solution

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.

Reply
igorsp
Scout

Re: First day of the next quarter?

Jump to solution

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)

View solution in original post

Reply