Change date format from number to DD/MM/YY

i have this : 44721 and i need this : 09/06/2022, how can i change it

Hello.

Try this:

DateTime.FromOADate(Double.Parse(cell.ToString))

Hug

I get the date from an excel in a sharepoint, but i don’t have the good format

I have this error :
image

image

The reason could be the variable “dated” is of String and the right-hand side of assign activity is giving you the Date type.

Check the data type of “dated” variable

how can i chose date time

If you click on “String” type then you would see a dropdown, you need to click on “More types” then you would see a very big list from there you need to select “DateTime” type

i have this :
image

i need also to change it to 09/06/2022 ==> dd/mm/yyyy and without 00:00:00

Try

dated.toString(“dd/MM/yyyy”)

Hey @Soudios

Another method:
image

image

Cheers

Steve