# Trigger Campaign Based on Date/Time
**URL:** https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262
**Category:** Development
**Created:** [October 17, 2016, 8:55pm UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262 "2016-10-17T20:55:18Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@mattk](https://forum.mautic.org/u/mattk)
#### Post date: [October 17, 2016, 8:55pm UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/1 "2016-10-17T20:55:18Z")
Has anyone been able to successfully find a way to trigger a campaign action based on a date/time field in the DB?
My business case is essentially the below:
A user books an appointment for a specific date/time. We would like to send a notification (i.e. reminder) the day before their scheduled appointment. This would essentially need to compare the current date/time to the date/time on the record.
Thoughts?
Also, if this isn’t available we’ll probably end up building out something like this - would anyone be interested in using a solution like this?
---
### Author:  [@mattk](https://forum.mautic.org/u/mattk)
#### Post date: [October 17, 2016, 8:55pm UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/2 "2016-10-17T20:55:18Z")
Has anyone been able to successfully find a way to trigger a campaign action based on a date/time field in the DB?
My business case is essentially the below:
A user books an appointment for a specific date/time. We would like to send a notification (i.e. reminder) the day before their scheduled appointment. This would essentially need to compare the current date/time to the date/time on the record.
Thoughts?
Also, if this isn’t available we’ll probably end up building out something like this - would anyone be interested in using a solution like this?
---
### Author:  [@Elenchus](https://forum.mautic.org/u/Elenchus)
#### Post date: [October 17, 2016, 10:00pm UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/3 "2016-10-17T22:00:20Z")
I can’t see a simple way to do this, but I’d certainly be interested in hearing if you find/create one
---
### Author:  [@Ethan](https://forum.mautic.org/u/Ethan)
#### Post date: [April 19, 2017, 9:31pm UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/4 "2017-04-19T21:31:36Z")
Yes I would use this feature if it were available.
---
### Author:  [@shanef](https://forum.mautic.org/u/shanef)
#### Post date: [April 23, 2017, 9:23am UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/5 "2017-04-23T09:23:59Z")
Great idea!! will use it!!
---
### Author:  [@seedofabraham](https://forum.mautic.org/u/seedofabraham)
#### Post date: [July 11, 2017, 4:21pm UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/6 "2017-07-11T16:21:16Z")
I have not used this yet but it looks promising:
[https://github.com/thirdset/ThirdSetMauticTimingBundle/blob/master/README.md](https://github.com/thirdset/ThirdSetMauticTimingBundle/blob/master/README.md)
@balkee listed a great solution, too:
[https://www.mautic.org/community/index.php/2771-sending-campaign-emails-during-specific-hours/0](https://www.mautic.org/community/index.php/2771-sending-campaign-emails-during-specific-hours/0)
---
### Author:  [@petertl](https://forum.mautic.org/u/petertl)
#### Post date: [July 12, 2017, 6:02am UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/7 "2017-07-12T06:02:28Z")
Create a segment with a filter like `[appointment date field] equals tomorrow`. Use this segment to feed a campaign with the reminder. One day before the appointment date, the contact is added dynamically to the segment and the reminder email is sent out.
Limitations:
- The reminder email will be sent out when the day changes (midnight)
- AFAIK the filter value accepts only “today”, “tomorrow”, “yesterday” - in your described case it is fine buf if you want to remind 2 days in advance you would need something like “today+2” which I could not test positively
---
### Author:  [@seedofabraham](https://forum.mautic.org/u/seedofabraham)
#### Post date: [July 17, 2017, 2:01am UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/8 "2017-07-17T02:01:33Z")
very creative @PeterTL!
---
### Author:  [@petertl](https://forum.mautic.org/u/petertl)
#### Post date: [July 17, 2017, 4:48am UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/9 "2017-07-17T04:48:55Z")
> [@24337:@seedofabraham](#):
>
> very creative @PeterTL!
I take that as a compliment!
---
### Author:  [@seedofabraham](https://forum.mautic.org/u/seedofabraham)
#### Post date: [July 17, 2017, 5:39pm UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/10 "2017-07-17T17:39:38Z")
> [@24341:@PeterTL](#):
>
> I take that as a compliment!
As you should, my fellow Mautic brother.
---
### Author:  [@rodrake](https://forum.mautic.org/u/rodrake)
#### Post date: [November 25, 2017, 6:40pm UTC](https://forum.mautic.org/t/trigger-campaign-based-on-date-time/6262/11 "2017-11-25T18:40:37Z")
I tryed this solution, but unfortunately, it doesn’t take in consideration time, only date. So if you need something to happen on a specific date/time custom field, it won’t work.