The-Strategy-Unit / experiencesdashboard

Shiny dashboard visualising and analysing patient experience data from the NHS England Friends and Family Test (https://www.england.nhs.uk/fft/)
https://connect.strategyunitwm.nhs.uk/qdc_public/
Other
8 stars 4 forks source link

date column is not properly parsed for some trust #173

Closed asegun-cod closed 1 year ago

asegun-cod commented 1 year ago

some users use ambiguous date formats when they upload their data to the dashboard. This is not well-handled resulting in dates such as these "0019-06-20". Some of the formats that have been used are "01-03-2021", "01-03-21", "01/03/2021", "01 03 2021".