Solved

Query List Action filter on Event Start Date not Working

  • 16 August 2016
  • 1 reply
  • 49 views

Badge +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

icon

Best answer by westerdaled 17 August 2016, 13:31

View original

1 reply

Badge +9

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

Reply