# Is there a problem with the scheduled date?

**URL:** <https://forum.mautic.org/t/is-there-a-problem-with-the-scheduled-date/28711>\
**Category:** General Discussion\
**Created:** [July 25, 2023, 8:15am UTC](https://forum.mautic.org/t/is-there-a-problem-with-the-scheduled-date/28711 "2023-07-25T08:15:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![gordon.hu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gordon.hu/32/5622_2.png) [@gordon.hu](https://forum.mautic.org/u/gordon.hu)\
**Post date:** [July 25, 2023, 8:15am UTC](https://forum.mautic.org/t/is-there-a-problem-with-the-scheduled-date/28711/1 "2023-07-25T08:15:42Z")

</div>

I noticed when I set the email frequency to once a week. The ‘scheduled date’ is calculated according to the time when the email is sent for the second time.  
For example:

1. Send A mail on 2023-07-20
2. On 2023-07-24, send A emails again. At this time, they will enter the queue and set the next scheduled date (2023-08-01).

Is there a problem with this scheduled date? Shouldn’t he be number 2023-07-27?

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [July 25, 2023, 9:38am UTC](https://forum.mautic.org/t/is-there-a-problem-with-the-scheduled-date/28711/2 "2023-07-25T09:38:54Z")

</div>

could you do a screenshot of your campaign and post here. do you have any specific days that you are telling when to send

---

<div class="post-metadata">

**Author:** ![gordon.hu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gordon.hu/32/5622_2.png) [@gordon.hu](https://forum.mautic.org/u/gordon.hu)\
**Post date:** [July 26, 2023, 1:09am UTC](https://forum.mautic.org/t/is-there-a-problem-with-the-scheduled-date/28711/3 "2023-07-26T01:09:54Z")

</div>

Sorry, I don’t have a screenshot of the campaign. I have two segmentA, segmentB, corresponding to A email template and B email template respectively. They both have C email addresses.

1. Send A email template on 2023-07-20
2. On 2023-07-24, send B the email template again. At this time, C email address, will enter the queue and set the next scheduled date (2023-08-01).

I can provide their records in emai\_stats and message\_queue tables.  
‘email\_stats’:  
±----------±---------±--------------------±— -----------------+  
| id | lead\_id | email\_address | date\_sent |  
±----------±---------±--------------------±— -----------------+  
| 368621865 | 21813251 | [demo@demo.com](mailto:demo@demo.com) | 2023-07-20 15:46:06 |

message\_queue:  
±----------±---------±--------------------±— -----------------±------------+  
| id | lead\_id | date\_published | scheduled\_date | last\_attempt |  
±----------±---------±--------------------±— -----------------±------------+  
| 151657116 | 21813251 | 2023-07-25 01:54:21 | 2023-08-01 01:54:21 | NULL |

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [July 26, 2023, 8:49am UTC](https://forum.mautic.org/t/is-there-a-problem-with-the-scheduled-date/28711/4 "2023-07-26T08:49:30Z")

</div>

> [@gordon.hu](#):
>
> 2023-07-25 01:54:21 | 2023-08-01

I see one week difference here:

2023-07-25 01:54:21 → 2023-08-01

There is something with the way you publish I believe. Are you using the weekdays only setting?

---

<div class="post-metadata">

**Author:** ![gordon.hu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gordon.hu/32/5622_2.png) [@gordon.hu](https://forum.mautic.org/u/gordon.hu)\
**Post date:** [July 26, 2023, 9:20am UTC](https://forum.mautic.org/t/is-there-a-problem-with-the-scheduled-date/28711/5 "2023-07-26T09:20:00Z")

</div>

> [@joeyk](#):
>
> I see one week difference here:
> 
> 2023-07-25 01:54:21 → 2023-08-01

Yes, there is a difference of one week here, but I think it is wrong. We should calculate the time one week after the last successful sending (2023-07-20 15:46:06 → 2023-07-27 15:46:06), instead of calculating one week after sending the email Time (2023-07-25 01:54:21 → 2023-08-01)

---

<div class="post-metadata">

**Author:** ![gordon.hu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/gordon.hu/32/5622_2.png) [@gordon.hu](https://forum.mautic.org/u/gordon.hu)\
**Post date:** [July 26, 2023, 9:21am UTC](https://forum.mautic.org/t/is-there-a-problem-with-the-scheduled-date/28711/6 "2023-07-26T09:21:01Z")

</div>

> [@joeyk](#):
>
> There is something with the way you publish I believe. Are you using the weekdays only setting?

No, I didn’t.