My Mautic version is: 3.1.2
My PHP version is: 7.3.24
My Database type and version is: 10.5.4-MariaDB
I was wondering if it is possible to create a segment based on the current Date AND Time. For example, if I have a campaign where I want to email someone when their subscription runs out. I don’t want to email them until it actually runs out, but would like to email them before the day is over.
The issue with using Today, is it just gives the current date without a time. So if I was to generate the segment when subscription end date = today, it would include people who don’t expire until later in the day. If I was to include subscription end date < today, people wouldn’t get added until tomorrow even if their accounts had already ended earlier today. Is there a build in feature like today that includes the time as well or would that be a feature request?
Basically if I was to re-generate the segments On March 1st at 4:00PM, I would like to be able to include anyone who’s subscription end date < March 1st, 4:00PM rather than < March 1st.
I couldn’t find a request to this feature, but if someone has already requested if someone could link me to it I could look at what would be required to create it.