Use date field for segmenting

Your software
My Mautic version is: v2.16.2
My PHP version is: 7.2.24
My Database type and version is: -

My Question
My problem is:

We are selling a saas product and every customer has an entry with a paid until date value, see image below:

We would like to be able to use this field to create a segment, the segment should contain all customers for which the paid until date is 2 weeks from now.

So today the segment should list all customers that are due to pay on dec 17.

How to setup the segment to achieve this?
Any help would be appreciated!

Not sure but you could try use Paid Until “equals”+14. Run the segment cronjob and see what happens.
I have tested this and it seems to be working.

Hi @mikew, thx for your reply.
I have tried it like this but that only gives me the accounts that expire today and not the ones that expire +14 days:

Did I do something wrong?

no that looks correct. What version of mautic are you running.

maybe try and write “+14 days”

1 Like

Hi @mikew, that fixed it, thx a lot!!

1 Like