Facebook Twitter Youtube Instagram

Events

SELECT `s`.show_id, STR_TO_DATE( `s`.start_date, '%m/%d/%Y' ) AS start_date, STR_TO_DATE( `s`.end_date, '%m/%d/%Y' ) AS end_date, UPPER(DATE_FORMAT(STR_TO_DATE( `s`.start_date, '%m/%d/%Y' ), '%M %d %Y')) AS start_day, UPPER(DATE_FORMAT(STR_TO_DATE( `s`.end_date, '%m/%d/%Y' ), '%M %d, %Y')) AS end_day, UPPER(DATE_FORMAT(STR_TO_DATE( `s`.start_date, '%m/%d/%Y' ), '%d')) AS day, UPPER(DATE_FORMAT(STR_TO_DATE( `s`.start_date, '%m/%d/%Y' ), '%b')) AS month, `s`.title, `s`.post_header, `s`.short_description, `s`.description, `s`.status, `s`.single_ticket, `s`.subscribe_show_listing, `s`.p_meta_keywords, `s`.p_meta_desc, `s`.back_image_credit, `s`.is_free, `s`.heading_picture, `s`.heading_picture_alt, `s`.background_picture, `s`.background_image, `s`.list_image, `s`.calendar_view_image, `s`.short_title, `s`.show_seo, `s`.event_type, `s`.running_time, `s`.group_event, `s`.ticket_link, `s`.related_show, `s`.quote, `short_cuts`.`source` AS `short_cuts`, `venue`.*, events.e_time, events.e_end_time FROM `shows` `s` LEFT JOIN `venue` ON `venue`.`v_id`=`s`.`show_venue` LEFT JOIN `events` ON `events`.`e_show_id`=`s`.`show_id` LEFT JOIN short_cuts ON short_cuts.destination = CONCAT('event-detail.php?id=', `s`.`show_id`) WHERE 1=1 AND STR_TO_DATE( `s`.`end_date`, '%m/%d/%Y' )>= CURDATE() AND (YEAR(STR_TO_DATE(`s`.`start_date`,'%m/%d/%Y')) >= YEAR(CURDATE()) OR YEAR(STR_TO_DATE(`s`.`end_date`,'%m/%d/%Y')) >= YEAR(CURDATE()) ) AND `s`.status=1 AND STR_TO_DATE(events.e_date, '%m/%d/%Y') > DATE_SUB(NOW(),INTERVAL 2 DAY) GROUP By `s`.`show_id` ORDER BY STR_TO_DATE( `s`.`end_date`, '%m/%d/%Y' ) ASC
Schaefer International Gallery
October 16, 2019
FREE ADMISSION
Schaefer International Gallery
October 17, 2019
FREE ADMISSION
A&B Amphitheater
October 18, 2019
FREE ADMISSION
Castle Theater
October 19, 2019
Castle Theater
October 20, 2019
October 24, 2019
Castle Theater
October 25, 2019
McCoy Studio Theater
October 27, 2019
A&B Amphitheater
November 01, 2019
A&B Amphitheater
November 02, 2019
Castle Theater
November 03, 2019
McCoy Studio Theater
November 08, 2019
Castle Theater
November 14, 2019
McCoy Studio Theater
November 17, 2019
McCoy Studio Theater
November 21 - November 24, 2019
A&B Amphitheater
November 24, 2019
FREE ADMISSION
McCoy Studio Theater
November 25, 2019
McCoy Studio Theater
November 29 - November 30, 2019
Castle Theater
December 01, 2019
Castle Theater
December 02, 2019
Yokouchi Pavilion and A&B Amphitheater
December 07, 2019
Castle Theater
December 10, 2019
FREE ADMISSION
Yokouchi Pavilion & Courtyard
December 13, 2019
McCoy Studio Theater
December 13, 2019
McCoy Studio Theater
December 14, 2019
Castle Theater
December 15, 2019
McCoy Studio Theater
December 20, 2019
McCoy Studio Theater
December 27, 2019
Castle Theater
December 28, 2019
McCoy Studio Theater
December 28, 2019
Castle Theater
December 29, 2019
Castle Theater
December 30, 2019
Castle Theater
January 02, 2020
A&B Amphitheater
January 03, 2020
Castle Theater
January 16, 2020
Castle Theater
January 23, 2020
Castle Theater
January 26, 2020
McCoy Studio Theater
January 30, 2020
McCoy Studio Theater
January 31, 2020
McCoy Studio Theater
February 06, 2020
Castle Theater
February 12, 2020
Castle Theater
February 23, 2020
Castle Theater
February 27, 2020
Castle Theater
March 06, 2020
Castle Theater
March 08, 2020
McCoy Studio Theater
March 12, 2020
McCoy Studio Theater
March 20, 2020
McCoy Studio Theater
March 21, 2020
Castle Theater
March 26, 2020
Castle Theater
March 27, 2020
McCoy Studio Theater
March 29, 2020
Castle Theater
April 09, 2020
McCoy Studio Theater
April 23, 2020
McCoy Studio Theater
April 24 - April 25, 2020
McCoy Studio Theater
May 09, 2020

DISPLAY By Category

PAST EVENTS

Maui Arts & Cultural Center
One Cameron Way
Kahului, HI 96732
Contact us

 

PLAN YOUR VISIT
Administration Office
Hours: Mon-Fri 9am – 5pm
808-242-ARTS (2787)

Box Office
Hours: Tue-Sat 10am – 6pm / 1-3 hrs prior to show times
808-242-SHOW (7469)

Schaefer International Gallery
Hours: Tue-Sun 10am – 5pm
808-242-2787
Facebook Twitter Youtube