westerdaled
Nintex Newbie

Query List Action filter on Event Start Date not Working

Jump to solution

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

0 Kudos
Reply
1 Reply
westerdaled
Nintex Newbie

Re: Query List Action filter on Event Start Date not Working

Jump to solution

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

View solution in original post

Reply