a charge amount is considered valid only for days between two columns: snap start date and snap end date