I have a SharePoint list containing two columns:
Date Type is a event while Dates contains the corresponding date to said event.
In my Nintex workflow, I am attempting to query a list in which it's been filtered where Date Type equals the name of the event AND Dates contains the MAX day for the current month. The latter is what I can't seem to get right. Can anyone provide some insight?
+22I'm now realizing I may have worded my question wrong. I'm not necessarily grabbing the last day of the month. It's a day near the end of the month with no pattern. That's why it's critical that I grab the greatest day in any given month from the mentioned list. Honestly, since each event only holds one date for any given month, I would even settle for getting the date in the Dates column that corresponds with the current month.
+6I just did a similar query, in my case, to get the maximum ID. When I queried the list, I set it to sort by ID, descending. Then I just use the first item in the collection ID, since it will be my maximum ID. Date should work the same way, or if your newest item is always your max date, you could use ID same as I did. That might be better if there's multiple entries on the same day.
List query:
Below is where I pull the first item ID:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
