In my Excel sheet, the actual data for 'valid until' is 28-12-2023. But when the bot types it into the text box, it appears as 12/28/2023 00:00:00

Help Studio
,
1

In my Excel sheet, the actual data for ‘valid until’ is 28-12-2023. However, when the bot types it into the text box, it appears as 12/28/2023 00:00:00. Can anyone help me clear this issue.

image
image1920×1080 331 KB

2

Hi,

Can you try to set DisplayValue at ReadFormatting in UseExcelFile activity?

image

Regards,

3

in excel visually presented values / formats are not mandatory the same within the datatable

As the datevalue from excel is maybe recognized after read range as a DateTime it will use the default format which is 12/28/2023 00:00:00

You can try:

  • parse the datacolumn value explicitly and controlled into a datetime
  • use the datetime and reformat it to a string within the needed format

For analysis steps have a look here:
:ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

4

Hi @krishnapriya_Anu ,
Excel have format
You used Modern or Classic activity?
if you use classic activity, you need convert format date (dd-MM-yyyy)
if you use modern activity, you can select “display value”
image

regards,

5

Is this a Correct process

image
image692×673 25.6 KB

6

HI,

It seems no problem. Do you still have format problem?

Regards,

7

But While running the bot, why isn’t the bot entering the ‘For Each Row’ loop in the Data Table?

image
image1002×685 25.3 KB

8

HI,

Can you elaborate? Do you mean CRM_QUOTE_DT is empty?

Regards,

9

Try This Logic

validUntilDate.ToString(“dd-MM-yyyy”)