Workflow and ServiceDesk Community

Hi,

I have created a table which has a column name DateOfAction, in that column user can insert the date whenever he wants to run a task. Now, I have created a workflow which will call the task reading it from SQL. I want to check that if DateOf Action matches the system date then only the task should run. Is there any sql query or workflow component which will check for the condition that given date is equal to system date,if it matches then only proceed for further execution or else end the workflow..

Thanks.

There are a set of workflow date components already provided... get current date, get month, get day, get year etc. You should be able to use these.

ya i saw that..but how do i compare that with my sql table column value???

There is a component named Date Greater Than that I use for a similar situation.  The First Date Variable Name is the value from your query and the Second Date would use a Dynamic Model to execute the Get Current Date component. 

With your SQL output, I'd inspect what "type" the date output is... if it's a Date/DateTime field you're fine. If it's a string, you can use the Convert String To Date comp to build a date from it. From there you can use any of the comparison components outlined in the post.

Okay found the solution.

Thanks all.