Date Conversion and Remove duplicates

[SandyCovey]

Hi,

I need to cleanse the "start date" column, which is currently formatted as DD/MM/YYYY HH:MM. I want to convert into just a date DD/MM/YYYY - I'm having problems, not sure if because of the data type.

Additionally, for each date, there may be two entries (morning and afternoon), so duplicate entries should be removed, leaving only one entry per day.

Lastly, in another column, I need to convert the date into the corresponding day of the week.

[binuacs · Accepted solution]

@SandyCovey one way of doing this

[lucasquintieri98]

Hello Sandy!

I came up with the attached solution, if you need any additional explanation about the tools I've used, let me know.