Today Plus 180 Days

[verde0903]

I have created a workflow to filter data where the end date is today + 180 but when I run it the data returns days past 180 days.  My filter created is [END_DATE] >= todate(DateTimeAdd(DateTimeToday(),180,"days")).  Thanks

[JosephSerpis]

Hi @verde0903 I mocked up a workflow that shows the filter you need to filter today plus 180 days from today date. Let me know what you think?

[Qiu]

@verde0903 
I think you workflow works just fine at my end. I have added some intermediate parameters to compare the results.

Or maybe its not >= you want? it is <=, or =?

[verde0903]

Thanks Joseph for the workflow.  It is retrieving the correct data.

[verde0903]

Thanks Qiu for the workflows.  I will review.