OA Date and How to Convert it to Normal date

Help Studio
,
1

Hello community i am new here and I want to know what is OA date and how i can convert it to normal date form.

Thanks

2

Hello @Ayush_Singh1 OA Date is type of date which is in numeric form and it is somewhat encrypted type but not fully to convert it into notmal date use this expression
DateTime.FromOADate(CDbl(YourOADate))

Cheers

3

hi, @Ayush_Singh1 To convert OA date to a normal readable date in UiPath, you can use this: DateTime.FromOADate(yourOADateValue)
Replace yourOADateValue with the OA date number you have. This will give you the normal DateTime format.

5

It is converting thanks for the help but i want it in dd/MM/yyyy format.

6

Okay so you can use DateTime.FromOADate(CDbl(OA Date)).ToString("dd/Mm/yyyy")
It will convert it into dd/MM/yyyy format

1 Like
Forum Engagement Daily Reports
7

It worked thanks for help.

1 Like
8

@Ayush_Singh1,

As a good practice, I would suggest to search on the forum before you post. There are already answered posts for this.

https://forum.uipath.com/search?q=OA%20date%20status%3Aclosed%20in%3Atitle%20order%3Alatest

1 Like