I have a column which captures the month the item was created.
How do I create a column which shows the month before this month?
Example:
Created month = FEB
New column would show month before = Jan.
Column to show what the month before is
+9
+7- Nintex Partner
Hey,
The solution in the thread below might point you in the right direction; https://community.nintex.com/t5/Nintex-for-SharePoint/How-to-get-previous-month-or-next-month-based-on-current-date-in/td-p/893
You can use the dateAdd-function in your form to add (or subtract) a month from one date, and then use the FormatDate-function to show the name of the calculated Month.
https://help.nintex.com/en-US/nwc/Content/Designer/Functions/dateAdd.htm
https://community.nintex.com/t5/Community-Blogs/Date-and-Time-Format-Strings-Quick-Reference-Guide/ba-p/81050
If you need any more help, let me know!
Kind regards,
Michel
The solution in the thread below might point you in the right direction; https://community.nintex.com/t5/Nintex-for-SharePoint/How-to-get-previous-month-or-next-month-based-on-current-date-in/td-p/893
You can use the dateAdd-function in your form to add (or subtract) a month from one date, and then use the FormatDate-function to show the name of the calculated Month.
https://help.nintex.com/en-US/nwc/Content/Designer/Functions/dateAdd.htm
https://community.nintex.com/t5/Community-Blogs/Date-and-Time-Format-Strings-Quick-Reference-Guide/ba-p/81050
If you need any more help, let me know!
Kind regards,
Michel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.