Topic
Instructions
Configure the action using the ISO 8601 date format for the date time value: 2017-05-15T00:00:00Z
Configure the action using the ISO 8601 date format for the date time value: 2017-05-15T00:00:00Z
This is exactly what I need, but, as I am new-ish to Nintex, I do not understand what I'm supposed to do in the instructions to make this work. Can someone elaborate on how to do this? I am trying to query a separate list in SharePoint to return a value if my date is greater than or equal to "Date From" and less than or equal to "Date To".
I tried using calculate date and then querying (a separate list) on the ISO 8601 date string, as follows:
I also tried converting the date field (within Sharepoint) on the other list to text and querying using the ISO 8601 date string and I have tried converting all dates (within Sharepoint) from both lists to text and querying using text. No results are returning, HOWEVER if I use the CAML editor and swap out the Value to a non variable date in ISO format (found this answer at Solved: Date filter in query list action not working - Nintex Community), the query returns values.
Thanks in advance!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.