Trying to calculate the last day of the next month. I have tried using the excel formula =EOMONTH(Date,1). A cast formula and a SQL formula. (I can't figure out the connection string and may not have access on the Excute SQL) easiest would be a calculated column, but could do it in a workflow or a calculated variable on the form. Is EOM a function in nintex and I am just missing it, or has anyone done this.
What I am running into is a situation where the due date is EOM but when I use Calculate date and add 1 month march is coming up 3/28/2020 instead of 3/31/2020.
Thank you for any help you can provide.