How to properly convert Date from excel to String?

[Palaniyappan (Palaniyappan P)]

Hi

May be let’s go one by one

Here the format is changing so as the column format in excel
That specific excel column has a different format
I would suggest to make it as TEXT so that we won’t face this format change issue

@bp777

The first question is why is that happening? I assume the proper format is 12:35:36 AM but still don’t understand why are cells populated with these odd format - 35:36.3

And for this

@bp777

Second thing I don’t understand is:
In the code, there is an assign dateTime = row(“Date Time”).ToString . Output for this assign is 44483 which is very weird.

If it is Text format in excel then this issue won’t come
As it is of different format it’s getting changed

In that case either we choose PRESERVE FORMAT in READ RANGE activity to get the formar as it is

Or

If it’s not working then once after getting the output like this 44483

Then use a Assign activity like this to get the value you want

Stroutput = DateTime.FromOADate(Convert.ToDouble(row(“yourcolumnname”).ToString)).ToString(“dd/MM/yyyy”)

This will give as the datetime in string format
You can change format you want

Cheers @bp777