Possible problem with cron settings solving

[arturkulik]

Hello,
we're using espo 9.1.8
with
SP 3.1.6
AP 3.11.7

on
PHP 8.3.21
Maria DB 10.6.22


My problem is that i set crontab like this:

and it should be at every first saturday of the monththat is between 1st and 7th day of every month at 00:10AM,
but i was executed at last saturday - 27th of september

like day of week is not part of AND conditions but it runs as OR

[yuri]

We use the library. https://github.com/espocrm/espocrm/b...poser.json#L24

We are unlikely to change this behavior.

Quick ChatGPT told that it has to be OR.

[yuri]

The generated text also does not certainly imply that it's OR. The "and" in natural language can be interpreted as logical "or".

[arturkulik]

We use the library. https://github.com/espocrm/espocrm/b...poser.json#L24

We are unlikely to change this behavior.

Quick ChatGPT told that it has to be OR.

Thank you for Quick answer the solution is:

for people with problem like mine there is a usefull link:

https://packagist.org/packages/dragonmantank/cron-expression

CRON Expressions


A CRON expression is a string representing the schedule for a particular command to execute. The parts of a CRON schedule are as follows:
* * * * *
- - - - -
| | | | |
| | | | |
| | | | +----- day of week (0-7) (Sunday = 0 or 7) (or SUN-SAT)
| | | +--------- month (1-12) (or JAN-DEC)
| | +------------- day of month (1-31)
| +----------------- hour (0-23)
+--------------------- minute (0-59)


Each part of expression can also use wildcard, lists, ranges and steps:

• wildcard - match always
  • * * * * * - At every minute.
  • day of week and day of month also support ?, an alias to *
• lists - match list of values, ranges and steps
  • e.g. 15,30 * * * * - At minute 15 and 30.
• ranges - match values in range
  • e.g. 1-9 * * * * - At every minute from 1 through 9.
• steps - match every nth value in range
  • e.g. */5 * * * * - At every 5th minute.
  • e.g. 0-30/5 * * * * - At every 5th minute from 0 through 30.
• combinations
  • e.g. 0-14,30-44 * * * * - At every minute from 0 through 14 and every minute from 30 through 44.

You can also use macro instead of an expression:

• @yearly, @annually - At 00:00 on 1st of January. (same as 0 0 1 1 *)
• @monthly - At 00:00 on day-of-month 1. (same as 0 0 1 * *)
• @weekly - At 00:00 on Sunday. (same as 0 0 * * 0)
• @daily, @midnight - At 00:00. (same as 0 0 * * *)
• @hourly - At minute 0. (same as 0 * * * *)

Day of month extra features:

• nearest weekday - weekday (Monday-Friday) nearest to the given day
  • e.g. * * 15W * * - At every minute on a weekday nearest to the 15th.
  • If you were to specify 15W as the value, the meaning is: "the nearest weekday to the 15th of the month" So if the 15th is a Saturday, the trigger will fire on Friday the 14th. If the 15th is a Sunday, the trigger will fire on Monday the 16th. If the 15th is a Tuesday, then it will fire on Tuesday the 15th.
  • However, if you specify 1W as the value for day-of-month, and the 1st is a Saturday, the trigger will fire on Monday the 3rd, as it will not 'jump' over the boundary of a month's days.
• last day of the month
  • e.g. * * L * * - At every minute on a last day-of-month.
• last weekday of the month
  • e.g. * * LW * * - At every minute on a last weekday.

Day of week extra features:

• nth day
  • e.g. * * * * 7#4 - At every minute on 4th Sunday.
  • 1-5
  • Every day of week repeats 4-5 times a month. To target the last one, use "last day" feature instead.
• last day
  • e.g. * * * * 7L - At every minute on the last Sunday.