hello chris i must admit this is also one of the best,

i am trying to show this date as well ,but i am getting error since this already CASTed.

(MAX(CASE WHEN daypart = 1 THEN in_time END) AS date) AS DATE_IN1,

(MAX(CASE WHEN daypart = 1 THEN out_time END) AS date) AS DATE_OUT1,

can you help me with DATE as well.

would be great to chk if any issues.