For a assignment I have to make it possible to collect all the data from the last 6 months and the next 6 months. I want to retrieve them with a microflow. I hope someone can help me.
asked
Bob Boons
1 answers
8
Create two variables both dates:
Variable1 named SixMonthsAgo, value = addMonths([%CurrentDateTime%],-6)
Variable2 named SixMonthsFuture, value = addMonths([%CurrentDateTime%],6)
Retrieve from the database and use an xpath like:
[createdDate >= $SixmonthsAgo]
[createdDate <= $SixmonthsFuture]
You should update to 5.16 or somewhat newer, I could have shared a MF on the model share