Date conversion issue

Can somebody show me what exactly I am doing wrong. i tried to convert text to Date with
d/MM/yyyy h:mm:ss AM/PM
format and having error.

Hi @bolud,

Try using tt instead of AM/PM in the Format setting.


I’m curious if you tried pressing the “Detect” button near the “Format” field. Theoretically, it should be able to detect the date format automatically.

I did try that and got “Couldn’t detect format in column [RequestedDate]”

Showing same error. This data is from sharepoint. I guess sharepoint might have some specific char in date string.When I open it in excel excel recognizes it as date… sharepoint date.csv (14.4 KB)

This works:

d/MM/yyyy h:mm:ss tt

Thanks a lot. It is working now… I guess I must have done something wrong before.