emha
Automation Master
Automation Master

Re: Comparing date value to today's date does not work in Query List

Jump to solution

hm, that all seems to be good.

just to be sure, you ran the workflow and did not get result. you didn't test just with run now in query dialog, did you?

it looks like variable does not resolve for unknown reasons to what is expected.

could you proof check there are not some non-printable characters in variable value? it may eg. happen that you accidentally typed space char (0x20) somewhere and nintex converted it to non breakable space (0xA0)

0 Kudos
Reply
emha
Automation Master
Automation Master

Re: Comparing date value to today's date does not work in Query List

Jump to solution

LEQ or GEQ, that  doesn't matter it should return some results.

for TODAY, try

      <Value Type="DateTime"><Today OffsetDays='-30' /></Value>
Reply
Not applicable

Re: Comparing date value to today's date does not work in Query List

Jump to solution

Dear Marian,

Oops! I did test with the run now in query dialog. I tried it in an actual workflow and it works! Thanks so much for troubleshooting this with me, you have been a great help!

And just in time for Christmas too! Happy holidays to you!

Cheers,

Chris

Reply
emha
Automation Master
Automation Master

Re: Comparing date value to today's date does not work in Query List

Jump to solution

great!

you can not expect run now will guess what might be a variable value at runtime. it simply takes it literally.

you always have to supply some sensefull data manually.

0 Kudos
Reply
rylander
Nintex Newbie

Re: Comparing date value to today's date does not work in Query List

Jump to solution

Thank You!! I've tried so many intense solutions and all I needed was to put the ^ Today string in the CAML editor to get it to work!

Reply
kalsup
Design Dabbler

Re: Comparing date value to today's date does not work in Query List

Jump to solution
You have no idea how long I was trying to get the whole date thing to work on query list. This worked for me as well. Thank you so much.
0 Kudos
Reply