Date conversion issue using uipath

[shilpashree.mohanty]

read range only but we cant check the preserve format option

[ptrobot]

Have you tested:

DateTime.FromOADate(41397).ToString("dd/MM/yy hh:mm:ss")

[Baskar_Gurumoorthy]

Okay can you try with reading the specific column

Activities - Read Column

Then try to work on the values

[shilpashree.mohanty]

tried
the string is being stored as a 5 digit numeric value
and then the conversion doesnt work

[Gautham_Pattabiraman]

@shilpashree.mohanty ,

Can you share a snap of the expression and flow.?

If you are having the value read from excel as string then replace yourExcelDate as Cint(yourExcelDate)

Date conversion issue using uipath

@shilpashree.mohanty Try this , Var1 = DateTime.FromOADate(yourExcelDate).ToString(“dd/MM/yyyy HH:mm:ss”) The above will give you the output as string type so use it in assign activity with a string type variable on the left side. For DateTime variable use, DateTimeVar= DateTime.ParseExact(var1, “dd/MM/yyyy HH:mm:ss”, CultureInfo.InvariantCulture) Hope this helps .

In the provided expression and try.

[shilpashree.mohanty]

unable to convert string to double

[ppr (Peter Preuss)]

have an example on a cascade to handle different scenarios

Linq query in excel date

@purnima_mandan when working with dates and Excel we check the datatable contents and will not rely at the visual presented format from excel Your Excel- read range with EAS: [grafik] Your excel - read range with Workbook [grafik] To find the latest date within a defensive approach we can do the following and run it against a prepared test set: [grafik] Checking totally invalid dates [grafik] Assign Activity: MaxDate | DateTime = (From d In dtData.AsEnumerable Where Not (isNothing(d(…

and feel free to adapt it to your scenario also by decomposing the LINQ to essential activities

[Gautham_Pattabiraman]

Hi @shilpashree.mohanty ,

Check the flow attached in the other thread you had created.

Date conversion issue from excel uipath

HI @shilpashree.mohanty , Check the attached flow, Change the Value in variables pane to test multiple cases. TestProcess.zip (26.3 KB) Thanks. Gautham.

Thanks,
Gautham.

[ptrobot]

Use CDbl to convert to double.

DateTime.FromOADate(CDbl("41397")).ToString("dd/MM/yy hh:mm:ss")

[shilpashree.mohanty]

getting this error,

[Ajay_Mishra (Ajay Mahendra Mishra)]

@shilpashree.mohanty Put this:

CDate(DateTime.FromOADate(CDbl(batchDateString)).ToString("MM/dd/yyyy hh:mm:ss"))

OR This:

DateTime.FromOADate(CDbl(batchDateString))

Regards,
Ajay Mishra

[shilpashree.mohanty]

second one works but output is in MM/dd/yyyy format

[ptrobot]

What is the type of the variable your are trying to assign the value to? If it’s DateTime, then skip the ToString() part.

yourDateVariable = DateTime.FromOADate(CDbl(batchDateString))

The expression I provided you returns a string:

[shilpashree.mohanty]

if i skip toString part its coming in MM/dd/yyyy format

[Ajay_Mishra (Ajay Mahendra Mishra)]

@shilpashree.mohanty

its coming in MM/dd/yyyy format

@shilpashree.mohanty Correct, Let me tell you UiPath by default DateTime format is MM/dd/yyyy only means firstly Month then date then year!

If you need Date first then you have to convert value in string format,

DateTime.FromOADate(CDbl(batchDateString)).ToString("dd/MM/yyyy hh:mm:ss")

Note Above query output will be String. So, In Assign left side vairable type should be String not Date.

Regards,
Ajay Mishra

[ptrobot]

If you skip the ToString() part, you will need to call it later when converting to a format you want.

yourDateVariable = DateTime.FromOADate(CDbl(batchDateString))
newformatDateString = yourDateVariable.ToString(“dd/MM/yy hh:mm:ss”)

[shilpashree.mohanty]

cant this be converted to date variable

[shilpashree.mohanty]

the final output should be date type - dd/MM/yyyy

[Ajay_Mishra (Ajay Mahendra Mishra)]

@shilpashree.mohanty Nope it’s not possible, can you tell me why you want the value as date type?

Regards,
Ajay Mishra

[shilpashree.mohanty]

to be printed in another excel