Change date format from number to DD/MM/YY

[Soudios (Sou)]

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

[Jose_Cunha (José Cunha)]

Hello.

Try this:

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

Hug

[Soudios (Sou)]

@Jose_Cunha

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

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

I have this error :

[manohar_e]

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

[Soudios (Sou)]

@Jose_Cunha

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

how can i chose date time

[manohar_e]

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

[Soudios (Sou)]

i have this :

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

[manohar_e]

Try

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

[Steven_McKeering]

Hey @Soudios

@Soudios

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

Another method:

Cheers

Steve