Project Timeline
SQL query for Ganttic
Get the start and end dates of each project.
SELECT project_id, MIN(start_date) AS project_start_date, MAX(end_date) AS project_end_date FROM tasks GROUP BY project_id
Ganttic data model
Users
Projects
Resources
Tasks
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed