Skip to main content
Nintex Community Menu Bar
Solved

Query List Action filter on Event Start Date not Working

  • August 16, 2016
  • 1 reply
  • 56 views
  • Translate

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
View original
Did this topic help you find an answer to your question?

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
Translate

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings