update for date-time clock and public holidays