cancel
Showing results for 
Search instead for 
Did you mean: 
bharathi
Nintex Newbie

iN THE QUERY LIST ACTION OF the workflow i want to query a field where its date equal to today's date with out time stamp

Jump to solution

I have to fetch the list items where a particular field value is equal to today's date using query list I tried for a variable with today's date and common variable current date then alos its not fetching the today's date values.

I

Reply
2 Replies
fhunth
Nintex Newbie

Re: iN THE QUERY LIST ACTION OF the workflow i want to query a field where its date equal to today's date with out time stamp

Jump to solution
Reply
Automation Master
Automation Master

Re: iN THE QUERY LIST ACTION OF the workflow i want to query a field where its date equal to today's date with out time stamp

Jump to solution

Do the linked solutions provide an answer you are looking for?

  • Using a calculated date in a workflow and finding all items greater or less than a date
  • Using a SharePoint calculated field as a value to compare against
  • Using a workflow variable with a default value

If you are required to have a date AND time stamp in your sharepoint field, then you will have to use a comparison of dates instead of equals to find those for a specified day. If you want to find all of today's, then you can use a comparison to find all items in the list where a Workflow Variable who's default value is Today and the time is set to 12 AM as shown in the first example

Pic2.jpg

Then you will compare the list in a query list action

Where

List Item Date is greater than Date (workflow variable)

This should only return the items who's date is after midnight today. note this will pick up any dates that are in the future if they exist.

0 Kudos
Reply