cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Query list filter by date returns empty result

So I'm trying to return items from a list that their notification date is equal to today's date.

Here's my list details -> ListA: itemname(text), duedate(date), notificationdate(date)

     notificationdate item default value is based on duedate - 4 months

    

 

In nintex WF designer, I did the following:

     1. Create a variable named todaysdate to store the current date value

     2. I added query list action to filter items when the notificationdate is equal to the current date(todaysdate)

 

However, when I run the query, it returns empty result although I checked that today's date matches the notificationdate value. and even when I enter the date manually exactly how its shown in ListA, it still returns empty result.

 

Untitled2.png

 

Untitled3.png

Labels: (1)
0 Kudos
Reply
5 Replies
Workflow Hero

Re: Query list filter by date returns empty result

Have you tried to find your answer in this thread :

https://community.nintex.com/message/7679#7679

or this blog :

https://community.nintex.com/community/build-your-own/blog/2015/01/15/how-to-query-sharepoint-list-i...

It seems you are trying to achieve the same thing!

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Query list filter by date returns empty result

Yes, actually I have looked at these two links. I followed exactly solution 2 of How to Query SharePoint List Item that were modified in Last X Days with Nintex Workflow? 

However, for some reason, it still returns empty result...

I spent hours investigating this and finally found that the date is in the wrong format... it should be like this yyyy-MM-ddTHH:mm:ssZ

Now I'm trying to use fn-dateformat function to format the current date but its not working properly

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Query list filter by date returns empty result

Be carefull with the "equal to" statement, cause it may try to look for a date (AND TIME) equality!

How have you configured you fields?

have you tried with a "greater than" instead?

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Query list filter by date returns empty result

Yes, at this stage, I have tried everything... Still returns an empty result.

The problem is within the date format it should be yyyy-MM-ddTHH:mm:ssZ instead of MM/dd/yyyy HH:mm:ss.

The date format function is not helping at all.

0 Kudos
Accept as Solution Reply
Workflow Hero

Re: Query list filter by date returns empty result

Any idea why it accepts this format only "yyyy-MM-ddTHH:mm:ssZ"? I checked my server

s date and time format and it's not the same.

and why the date format function isn't functioning properly? It returns this "fn-dateFormat(5/24/2015, 'dd/mm/yyyy')" and not the value or even empty string..

0 Kudos
Accept as Solution Reply