I want to convert excel custom to date format in uipath

Help Studio
, ,
1

image
image1091×428 23.3 KB

image
image1023×641 33.9 KB

in excel my date format is in custom and i am using Convert.ToDateTime(CurrentRow.Field(Of String)(“Transaction Date”).Substring(0, 19)).ToString(“dd-MMM-yy”) this to convert the excel date to 19-feb-25 but i am getting above error .can some one help me in this ?

2

hi @SSD

Try this
Convert.ToDateTime(CurrentRow.Field(Of String)(“Transaction Date”).ToString.Split(" ")(0)).ToString(“dd-MMM-yy”)

Hope this helps

4

image
image1346×565 33.7 KB

still getting this error

5

Hi @SSD

Try the below syntax:
FormattedDate = DateTime.ParseExact(CurrentRow("Transaction Date").ToString.Split(" ").First(), "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MMM-yyyy")

If possible share sample input excel, I will help you out

6

image
image1041×521 27.4 KB

getting this error

7

Hi @SSD

Can you share the excel if possible.

Regards

8

date.xlsx (348.0 KB)

9

@Parvathy can u help plz its urgent isssue

10

Hi @SSD

Check the below workflow:

Sequence2.xaml (9.0 KB)

Hope it helps!!

11

image
image1152×850 37 KB

still getting this error
@Parvathy

12

Hi @SSD

Can you share the workflow file.

Regards

13

@SSD
You’re getting this issue because Excel stores dates as serial numbers, and when you read the Excel file in UiPath, it might interpret the date column as a double (numeric) value instead of a proper DateTime format.

Why is this happening?

  1. Excel stores dates as serial numbers:
  • 1 = 01/01/1900
  • 45689 = 07/05/2025 (Example)
  • 45689.12800925926 → Includes time portion as a decimal.
  1. UiPath reads the value as a string or double:
  • When reading Excel data using the Read Range activity, dates might be interpreted as doubles instead of DateTime.

Fixing the Issue

Solution 1: Convert Excel Serial Number to DateTime

If the value is stored as a number in the DataTable, convert it using:

DateStringVariable = DateTime.FromOADate(CDbl(row("Transaction Date").ToString())).ToString("dd-MMM-yy")

This will convert the serial number to an actual DateTime format.

Solution 2: Preserve Formatting in Read Range

  • If you are using the Workbook Read Range, try switching to the Excel Application Scope and enable the PreserveFormat property.

Hope this helps

14

@SSD

Date is coming in Double or OAdate format…try using this

DateTime.FromOAdate(currentRow(0).ToString).ToString("dd-MM-yy")

cheers