Retrieve records between dates

0
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
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

answered