I am facing problems with date format in Nintex workflow with CAML query.The issue is If I use date as 2015-06-15, my workflow is works. If I replace the same with <Today OffsetDays="-1"/> the query is not returning any result. I have the date column in the following format 6/15/2015 06:00 AM
Please help in achieving this in CAML query.
Hi, which Nintex Workflow Platform are you using?
also what is the <Value Type> - DateTime or String?
The <Today> and the <Today OffsetDays="-1"/> works when <Value Type> is DateTime e.g. <Value Type='DateTime'>
Can you try to verify both CAML Query using PowerShell.
Refer to this article
How to Query a list with CAML via PowerShell
Also you probably meant 2022-06-15 and not 2015-06-15
Perhaps you could also share your CAML query.
Cheers
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.