cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

Column to show what the month before is

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.

 

Labels: (1)
0 Kudos
Reply
1 Reply
Highlighted
Nintex Newbie

Re: Column to show what the month before is

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-...

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/b...

If you need any more help, let me know!

Kind regards,
Michel
0 Kudos
Reply