cancel
Showing results for 
Search instead for 
Did you mean: 
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
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
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