Add Date Column

[beginner_x]

I have a column named as 'timestamp per day' and the cells contain dates with format like this '13/11/2023'.
As I try to add a Date column, I'm only getting 'Parse' on the drop down list.
I already tried to change the date type into Date or Date/Time or Date/Time/Zone but neither works, I always get an error in some of my data though they all have the same format as 'DD/MM/YYYY'.
As I also click the Parse option, it also gave me same error:

DataFormat.Error: We couldn't parse the input provided as a DateTime value.

Details

Reason = DataFormat.Error

Detail = 13/11/2023

Please help. Thanks!

[beginner_x]

This is helpful! Just by changing the regional settings of the files alone works for me. Thanks!

[serpiva64 · Accepted solution]

Hi,

you need to use Using Locale instead of Date

and then select one Locale which has the format for date DD/MM/YYYY like italy

and it will function.

You can also decide to change Regional settings in Options

to Italy

and you will get the dates in the format you need

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !