potiuk opened a new issue, #33375: URL: https://github.com/apache/airflow/issues/33375
### Discussed in https://github.com/apache/airflow/discussions/33345 <div type='discussions-op-text'> <sup>Originally posted by **vuphamcs** August 11, 2023</sup> ### Description Is there a variable similar to `prev_start_date_success` but for the previous DAG run’s completion date? The value I’m hoping to retrieve to use within the next DAG run is `2023-08-10 16:04:30`  ### Use case/motivation One particular use case is to help guarantee that the next DAG run only queries data that was inserted during the existing DAG run, and not the past DAG run. ```python prev_ts = context['prev_end_date_success'] sql = f"SELECT * FROM results WHERE created_at > {context['prev_end_date_success']}" ``` ### Related issues _No response_ ### Are you willing to submit a PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md) </div> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
