See objects expire within 6 months

0
Hi, I would like to see all ‘Aansluitingen’ that expire within six months. I thought maybe I can use the EndofCurrentMonth and add 5 months to it. That didn't work.  How can I make sure I see those which expire within 6 months?
asked
3 answers
3

You are almost there:

Regards,

Ronald

[EDIT] see the documentation here: https://docs.mendix.com/refguide/xpath-keywords-and-system-variables/

answered
0

Hi Christine!

 

If you're using an Xpath, you need to create a new attribute for that with the ‘ExpireDate' that is calculated somewhere else using the addMonths function.

 

Another option is to use a microflow as Data Source here and determine there which records you want to see on the page using the same function in that microflow.

 

Good luck!

 

Kind regards,

Mark

answered
0

You could try the addMonths functionality, so your xpath would look something like this:
 

[EinddatumAansluiting <= addMonths([%CurrentDateTime%], 6)]

 

answered