corrected using time zone in TRUNCATE(Date,DAY,GMT-4)