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
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
Could you please show the formula for false cells ?
It is an equals formula
the uipath entered date is in string format which throws false
Regards,
Supriya
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
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
Okay Thanks.
Why are you using + in your formula before D11
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
Hey @supu123
Sorry for a bit late reply.
Please find the workaround for your issue.
B3
B2 and check the result of the formula
Hope this is what you are looking for.
Thanks
#nK