refinements including converting BGN_DATE to Date format for time series analysis