The web interface of airflow is not showing the correct dag execution date, rather it shows the second last execution date of the dag run.
I also have another query related to this:
I wanted to get the list of dags that were supposed to run today but did not.
This is a common misconception about Airflow. The date shown in 'Last Run' is not the date that the DAG actually ran on.
I'd encourage you to read up on the Airflow documentation in this regard.
https://airflow.apache.org/scheduler.html
On the topic, see this article for the details about the โdatesโ. https://caserta.com/data-blog/airflow-tips-tricks-pitfalls/
Most helpful comment
This is a common misconception about Airflow. The date shown in 'Last Run' is not the date that the DAG actually ran on.
I'd encourage you to read up on the Airflow documentation in this regard.
https://airflow.apache.org/scheduler.html