updated datetime parsing for cohort analysis