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
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?
@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 =?
Thanks Joseph for the workflow. It is retrieving the correct data.
Thanks Qiu for the workflows. I will review.