ScottEngine
Rookie

Query List - Dates "String was not recognized as a valid DateTime."

Hello, 

 

Im relatively new to Nintex, having issues with the following, 

im running a Query that looks at all the items in the lists and compares the date in the column (WF Date) to a variable in the workflow (DATE_Today).

Currently using "add time to date" set date to "use date when action is executed"

When i log i get the value in this format "24/08/2021  3:17:17 PM"

then use a query to compare and get the ""String was not recognized as a valid DateTime." error.

 

i set up a test query to get the WF Date values to look and they are formatted as ""2021-10-24T14:00:00Z"

 

how do i fix this?

Labels: (1)
0 Kudos
Reply
2 Replies
ScottEngine
Rookie

Re: Query List - Dates "String was not recognized as a valid DateTime."

is there anyone who can help with this?

0 Kudos
Reply
ScottEngine
Rookie

Re: Query List - Dates "String was not recognized as a valid DateTime."

Bump??
0 Kudos
Reply