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.
Have you tried to find your answer in this thread :
or this blog :
It seems you are trying to achieve the same thing!
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
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?
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.
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..