Spreadsheet: 47875d1247045648-calender-table-lookup-query-test-query
Sheet: Critical Path Query

Company | Department | Category name | Season_Name | Season_Start_date | Season_End_date | Path_Name | Path_date_start | Path_date_end
Ajax | Boys/Men | Apparel | Summer T1 | 2008-07-01 00:00:00 | 2008-08-31 00:00:00 | 1-Review | 2008-08-20 00:00:00 | 2008-08-31 00:00:00
Ajax | Boys/Men | Apparel | Summer T1 | 2008-07-01 00:00:00 | 2008-08-31 00:00:00 | 2-Buying trips | 2008-09-01 00:00:00 | 2008-09-23 00:00:00
[NAME] | General | Apparel | Christmas | 2008-11-11 00:00:00 | 2008-12-24 00:00:00 | 1-Review | 2008-07-01 00:00:00 | 2008-07-30 00:00:00
Bones | Apparel- Men | Apparel | Spring | 2008-07-01 00:00:00 | 2008-09-30 00:00:00 | 2-Buying trips | 2008-12-01 00:00:00 | 2008-12-31 00:00:00
Bones | Apparel- Men | Apparel | Spring | 2008-07-01 00:00:00 | 2008-09-30 00:00:00 | 3-Compile range | 2008-01-01 00:00:00 | 2008-01-31 00:00:00
Bones | Apparel- Men | Apparel | Spring | 2008-07-01 00:00:00 | 2008-09-30 00:00:00 | 4-Approve range | 2008-02-01 00:00:00 | 2008-02-28 00:00:00
Bones | Apparel- Men | Apparel | Spring | 2008-07-01 00:00:00 | 2008-09-30 00:00:00 | 5-Place & order | 2008-03-01 00:00:00 | 2008-03-07 00:00:00
Bones | Apparel- Men | Apparel | Summer | 2008-10-01 00:00:00 | 2008-02-28 00:00:00 | 2-Buying trips | 2008-03-01 00:00:00 | 2008-03-31 00:00:00
Bones | Apparel- Men | Apparel | Summer | 2008-10-01 00:00:00 | 2008-02-28 00:00:00 | 3-Compile range | 2008-04-01 00:00:00 | 2008-05-31 00:00:00
Bones | Apparel- Men | Apparel | Summer | 2008-10-01 00:00:00 | 2008-02-28 00:00:00 | 4-Approve range | 2008-06-01 00:00:00 | 2008-06-30 00:00:00
Bones | Apparel- Men | Apparel | Summer | 2008-10-01 00:00:00 | 2008-02-28 00:00:00 | 5-Place & order | 2008-07-01 00:00:00 | 2008-07-10 00:00:00
Bones | Apparel- Men | Apparel | Winter | 2008-03-01 00:00:00 | 1931-06-01 00:00:00 | 2-Buying trips | 2008-10-01 00:00:00 | 2008-10-31 00:00:00
Bones | Apparel- Men | Apparel | Winter | 2008-03-01 00:00:00 | 1931-06-01 00:00:00 | 3-Compile range | 2008-11-01 00:00:00 | 2008-11-30 00:00:00
Bones | Apparel- Men | Apparel | Winter | 2008-03-01 00:00:00 | 1931-06-01 00:00:00 | 4-Approve range | 2008-12-01 00:00:00 | 2008-12-31 00:00:00
Bones | Apparel- Men | Apparel | Winter | 2008-03-01 00:00:00 | 1931-06-01 00:00:00 | 5-Place & order | 2008-01-01 00:00:00 | 2008-01-10 00:00:00
Bones Home store | Apparel | Apparel | Spring | 2008-06-01 00:00:00 | 2008-08-31 00:00:00 | 2-Buying trips | 2008-02-01 00:00:00 | 2008-02-28 00:00:00
Bones Home store | Apparel | Apparel | Spring | 2008-06-01 00:00:00 | 2008-08-31 00:00:00 | 3-Compile range | 2008-03-01 00:00:00 | 2008-03-31 00:00:00
Bones Home store | Apparel | Apparel | Spring | 2008-06-01 00:00:00 | 2008-08-31 00:00:00 | 5-Place & order | 2008-04-01 00:00:00 | 2008-04-10 00:00:00
Bones Home store | Apparel | Apparel | High Summer | 2008-09-01 00:00:00 | 2008-12-31 00:00:00 | 2-Buying trips | 2008-04-01 00:00:00 | 2008-04-30 00:00:00
Bones Home store | Apparel | Apparel | High Summer | 2008-09-01 00:00:00 | 2008-12-31 00:00:00 | 3-Compile range | 2008-05-01 00:00:00 | 2008-05-31 00:00:00
Bones Home store | Apparel | Apparel | High Summer | 2008-09-01 00:00:00 | 2008-12-31 00:00:00 | 5-Place & order | 2008-06-01 00:00:00 | 2008-07-10 00:00:00