Date conversion issue

1

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.

text%20to%20date
text to date.png905×396 27.8 KB

2

Hi @bolud,

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

3

@bolud,

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.

4

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

5

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)

6

This works:

d/MM/yyyy h:mm:ss tt

image
image.png937×614 20.5 KB

7

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