I have 2 dates in an excel spreadsheet which is not conforming to the custom format yyyy-mm-dd hh:mm:ss. How do I fix them?
Check if that is added as text…to see that once cell is selected check value from the top panel and see if that value has a single literal at the start
Cheers
this is what I am seeing:
Are there any spaces at the start…and also the format is custom only? And the same format is selected?
Just to verify can you check the other values how they look to see the difference
Cheers
there are no spaces at the start, the format is the same custom format for all the rows
yyyy-mm-dd hh:mm:ss
Hi @Nyx ,
Could you try using the Format Cells activity and keep the Data Type as custom and check whether the column will be updated as provided :
I have used that via UiPath already and those 2 dates are the ones which do not conform
Anyone have any idea how to resolve this date issue?
Siebel EBU_2023-07-12-08-53-57.xlsx (14.0 KB)
@Anil_G - any luck with the solution?
One thing I observed is the issue is in the input you provided
When I read the data everything comes this way and only one particular which is errored out comes different
This should be tackled there or another way would be to use for loop and parse each date and see which does not comply and then replace those dates properly…for this we need to know which are formats the date would take…is it only dd-MM-yyyy hh:mm:ss or are there other wrong formats also
cheers
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale