Cleaning dates that also include a time stamp

[pbkeating]

Hi @zkamvar

Some colleagues here having to manage date variables that include a mixture of formats e.g. some regular dates dd-mm-yyyy and others with dd-mm-yyyy hh:mm:ss. Usually due to having people manually add dates (only dates) to excel sheets where the standard format is dates with timestamps.

Would it be possible to include in the clean_dates() function the ability to identify the dd-mm-yyyy with timestamps as regular dates also i.e. to remove the timestamps from them?

Let me know if that's clear. Thanks, P

[zkamvar]

Hi @pbkeating,

This is already possible, see the examples in https://www.repidemicsconsortium.org/linelist/reference/guess_dates.html

Sent from my iPhone

On Apr 17, 2019, at 07:51, pbkeating notifications@github.com wrote:

Hi @zkamvar

Some colleagues here having to manage date variables that include a mixture of formats e.g. some regular dates dd-mm-yyyy and others with dd-mm-yyyy hh:mm:ss. Usually due to having people manually add dates (only dates) to excel sheets where the standard format is dates with timestamps.

Would it be possible to include in the clean_dates() function the ability to identify the dd-mm-yyyy with timestamps as regular dates also?

Let me know if that's clear. Thanks, P

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub, or mute the thread.

[pbkeating]

Thanks, Zhian. A colleague here will send through an example of problems she had with mixed formats that clean_dates() didn't seem to clean.

P

[zkamvar]

Thanks, Zhian. A colleague here will send through an example of problems she had with mixed formats that clean_dates() didn't seem to clean.

P

I'm assuming then that these are a different issue and will close this