Skip to main content
Nintex Community Menu Bar
Solved

Query List Action filter on Event Start Date not Working

  • August 16, 2016
  • 1 reply
  • 57 views

Forum|alt.badge.img+9

Hi

 

I want my workflow to pick a date based on the  relevant Events in a Calendar list.  I can lookup an Event  (meeting start ) date based on a user selected category in my form.  I do however, want to go one step further by ensuring  the lookup can only select an Events in the future for the given category.

 

When I try to add my filter on Start Date using Current Item: Modified I seem get bizarre string conversion errors at runtime such as

 

String not recognized as a valid DateTime

 

Note if want to use Modified in DateTime  format I simply get a runtime error.  Sigh ;-(

 

 

Workflow Query list not allowing a filter on start date.png

Best answer by westerdaled

Hi

I actually solved this by

  1. Creating a calc field in the list which holds the Start Time
  2. Creating a new ( default view) on my Calendar list which has filter on [Calc Start Time] > [Today] , so as to filter out any past events

1 reply

Forum|alt.badge.img+9
  • Author
  • 84 replies
  • Answer
  • August 17, 2016

Hi

I actually solved this by

  1. Creating a calc field in the list which holds the Start Time
  2. Creating a new ( default view) on my Calendar list which has filter on [Calc Start Time] > [Today] , so as to filter out any past events