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

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.

Hi,

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

image

Regards,

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

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,

Is this a Correct process

HI,

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

Regards,

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

HI,

Can you elaborate? Do you mean CRM_QUOTE_DT is empty?

Regards,

Try This Logic

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