Date Format In excel

Hi team,

need an help even after adding date to excel the comparison is false

Explaining in detail

As per NAV Check date is entered by client

As per life asia date is entered by uipath bot by using write range date.tostring

but after opening file the comparison comes to be false

it should be true

how to solve this

Thanks and Regards,
Supriya Galentic

Hey @supu123

What’s the formula you are using for date comp in excel.

And can you focus the cell which is written by bot to check the format.

Thanks
#nK

Hi @Nithinkrishna

To excel I m writing dd-mm-yyyy.tostring

when checking in excel it is a string format

how to write to excel in date format

Thanks and Regards,
Supriya

1 Like

Could you please show the formula for false cells ?

Hi @Nithinkrishna

It is an equals formula

the uipath entered date is in string format which throws false

Regards,
Supriya

1 Like

Ok now just one more thing I need confirmation from you… ExcelType of the date cells manually entered type and bot entered cell type

Not the bot type as it is anyway a string, but the excel type on the top

Can u please explain in simpler terms

1 Like

I have marked in the below image. Please check.

The arrow mark shows the type for which I was asking.

You need to please show me the type for the dates entered by humans and bots (any one cell for each which is also marked)

Thanks
#nK

For both the cases the type is date only

Thanks and Regards,
Supriya

1 Like

Okay Thanks.

Why are you using + in your formula before D11

  • represents a positive value in excel
1 Like

Could you please try removing it and check if it’s gives expected result…

Even if the + is removed answer is same

Basically the date is in the text value format of excel which need to be in date_value

How to do this

1 Like

Hey @supu123

Sorry for a bit late reply.

Please find the workaround for your issue.

  1. Excel formula configuration

image

  1. Executing my bot to write the string date in B3

  1. Bot has written the value in B2 and check the result of the formula

image

Hope this is what you are looking for.

Thanks
#nK