schedule_interval do not work the cron expression for week days with day of month interval

[jenergm]

Apache Airflow version

2.10.3

If "Other Airflow 2 version" selected, which one?

No response

What happened?

When I try using the cron expression "0 10 1-7 * 1". Must execute the first monday at 10am for each month but it executes the first seven days of each month at 10am.

What you think should happen instead?

Must execute the first monday at 10am for each month.

How to reproduce

Try set the cron expression "0 10 1-7 * 1" in schedule_interval in a dag definition.

Operating System

Oracle Linux Server 7.9

Versions of Apache Airflow Providers

apache-airflow-providers-amazon==9.0.0
apache-airflow-providers-celery==3.8.3
apache-airflow-providers-cncf-kubernetes==9.0.1
apache-airflow-providers-common-compat==1.2.1
apache-airflow-providers-common-io==1.4.2
apache-airflow-providers-common-sql==1.19.0
apache-airflow-providers-docker==3.14.0
apache-airflow-providers-elasticsearch==5.5.2
apache-airflow-providers-fab==1.5.0
apache-airflow-providers-ftp==3.11.1
apache-airflow-providers-google==10.25.0
apache-airflow-providers-grpc==3.6.0
apache-airflow-providers-hashicorp==3.8.0
apache-airflow-providers-http==4.13.2
apache-airflow-providers-imap==3.7.0
apache-airflow-providers-microsoft-azure==11.0.0
apache-airflow-providers-mysql==5.7.3
apache-airflow-providers-odbc==4.8.0
apache-airflow-providers-openlineage==1.13.0
apache-airflow-providers-postgres==5.13.1
apache-airflow-providers-redis==3.8.0
apache-airflow-providers-sendgrid==3.6.0
apache-airflow-providers-sftp==4.11.1
apache-airflow-providers-slack==8.9.1
apache-airflow-providers-smtp==1.8.0
apache-airflow-providers-snowflake==5.8.0
apache-airflow-providers-sqlite==3.9.0
apache-airflow-providers-ssh==3.14.0

Deployment

Docker-Compose

Deployment details

Docker Compose version v2.18.1

Docker version 24.0.2, build cb74dfc

Anything else?

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[boring-cyborg[bot]]

Thanks for opening your first issue here! Be sure to follow the issue template! If you are willing to raise PR to address this issue please do so, no need to wait for approval.

[ES00660463]

+1

[eladkal]

When I try using the cron expression "0 10 1-7 * 1". Must execute the first monday at 10am for each month but it executes the first seven days of each month at 10am.

Must execute the first monday at 10am for each month.

This cron expression doesn't say what you think it say.

https://crontab.guru/#0_10_1-7_*_1

Either find a cron expresion that says what you wish or use Timetable if you need customize behavior

[jenergm]

When I try using the cron expression "0 10 1-7 * 1". Must execute the first monday at 10am for each month but it executes the first seven days of each month at 10am.

Must execute the first monday at 10am for each month.

This cron expression doesn't say what you think it say.

https://crontab.guru/#0_10_1-7_*_1

Either find a cron expresion that says what you wish or use Timetable if you need customize behavior

Hi Elad,

What I need is it must run once a month in the first monday of month at 10AM.

The problem is that cron must be right, but it seams doing an OR condition instead of AND. It's running on other week days.

[Pavan-talluri]

Hi @jenergm,

We are also dealing with this and we found that its just that Unix cron functions this way. it is not programming and operator its just plain english and

airflow scheduler uses default
CronDataIntervalTimetable
[https://github.com/apache/airflow/blob/4ffa6afc721ab99a974bb8bbda74b1d9300ae456/airflow/timetables/interval.py#L119]

for processing crons which underlying uses croniter library for processing crons. You can this as reference and write timetable class

[github-actions[bot]]

This issue has been automatically marked as stale because it has been open for 14 days with no response from the author. It will be closed in next 7 days if no further activity occurs from the issue author.

[jenergm]

Hi @jenergm,

We are also dealing with this and we found that its just that Unix cron functions this way. it is not programming and operator its just plain english and

airflow scheduler uses default CronDataIntervalTimetable [https://github.com/apache/airflow/blob/4ffa6afc721ab99a974bb8bbda74b1d9300ae456/airflow/timetables/interval.py#L119]

for processing crons which underlying uses croniter library for processing crons. You can this as reference and write timetable class

Hi @Pavan-talluri,

Have you some example creating and using timeline classes?

Better if it works just using the correct cron expression.

Thanks in advance!