refine date parsing so missing dates will not throw error for non-db transactions