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

Find the month based on a column

Jump to solution

I have a date/time column in SharePoint 2013 list. I'd like to use Nintex to determine the month of that date/time column. I will have to filter that list later based on the recent month items. So I would need to be able to pull items that are dated for April. Next month, I'd have to pull items for May, etc.

Reply
16 Replies
fhunth
Nintex Newbie

Re: Find the month based on a column

Jump to solution

I'd add a new column on the SharePoint list with a formula to get the month

Reply
burkslm
Nintex Newbie

Re: Find the month based on a column

Jump to solution

Yeah, I figured I'd add a column but I didn't know what the formula would be to get the month.

0 Kudos
Reply
Automation Master
Automation Master

Re: Find the month based on a column

Jump to solution

burkslm​ Assuming you've got a SharePoint list date column named 'TestDate', these formulas used in calculated columns will give you what you need:

  • =TEXT([TestDate],"mm")
    • Returns 01 if date is 12-Jan-2015
  • =TEXT([TestDate],"mmmm")
    • Returns January if date is 12-Jan-2015
  • =TEXT([TestDate],"mmm")
    • Returns Jan if date is 12-Jan-2015
Reply
burkslm
Nintex Newbie

Re: Find the month based on a column

Jump to solution

I have a date column that is in the format of 4/13/2016. Will your solution still work?

0 Kudos
Reply
burkslm
Nintex Newbie

Re: Find the month based on a column

Jump to solution

And I need it to be in the datatype of a number not text. Because I will need to compare using <>=

0 Kudos
Reply
Automation Master
Automation Master

Re: Find the month based on a column

Jump to solution

Yes this format won't be a problem – it's the format I tested against:

Screen Shot 2016-04-13 at 2.20.49 PM.png

0 Kudos
Reply
Automation Master
Automation Master

Re: Find the month based on a column

Jump to solution

If you're need the month number (int), just use the first of the three formulas I posted : =TEXT([TestDate],"mm"). This will return '04' for 4/14/2016.

View solution in original post

Reply
burkslm
Nintex Newbie

Re: Find the month based on a column

Jump to solution

I want to return 4 not April.

0 Kudos
Reply
burkslm
Nintex Newbie

Re: Find the month based on a column

Jump to solution

I hate to be a pain, but I don't want to have leading 0s. I'm going to have to do comparisons. I was getting an error when I did what you posted.

0 Kudos
Reply