date difference
date_differenceCalculate the difference between two dates in days, weeks, months, years, and business days. Accepts dates in YYYY-MM-DD format. Returns the absolute difference (order doesn't matter) plus a flag indicating whether the end date is in the future relative to start. Business days count only Monday through Friday. Useful for project planning, deadline tracking, contract duration calculations, and age computations.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| end_date | Yes | End date in YYYY-MM-DD format (e.g., '2024-12-31'). | |
| start_date | Yes | Start date in YYYY-MM-DD format (e.g., '2024-01-15'). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| days | Yes | Total number of days between the two dates (absolute value). | |
| weeks | Yes | Number of complete weeks. | |
| years | Yes | Approximate number of years (days / 365.25). | |
| months | Yes | Approximate number of months (days / 30.44). | |
| is_future | Yes | True if end_date is after start_date. | |
| business_days | Yes | Number of weekdays (Monday-Friday) between the dates. |