Date format in web page is yyyy-mm-dd.
Same format is there in excel file. I have used format value as well to ensure the date is correct yet there is no 100% accuracy.
Can anyone please guide how to make the workflow run seamlessly.
Welcome to the community
Generally its better to format it before entering as when read from excel the format might change
Or ither option would be when using read range activity use display value as the format so that the value is read as is
Or use cdate(valuefromexcel).ToString("yyyy-MM-dd") this will ensure format is proper
Both of the above ways would work
Cheers
Hello @Rakshith
If you can see that the date is typed in the expected format, then perhaps add Enter being pressed in the end, to confirm the input.
Regards
Soren
Hi @Rakshith
Welcome to UiPath,
use datetime.parseexact with “yyyy-MM-dd”. click date field before input. send ctrl+a and backspace to clear. use set text if type into fails. use .date.tostring(“yyyy-MM-dd”) to strip time.
If helpful, mark as solution. Happy automation with UiPath
@Anil_G Thanks for your response.
The formatting is working before it is typed and the format is clear in message box.
When it types in the box on the webpage it is so fast and looks like page is slow which makes one of the number missing and it crashes, then when I click retry it works, but I want it to work in one go.
Then in type into you have a verify option use that so that if failed it would retry
Or use a delay between keys option to make it little slow
Ideally simulate works better as input method
Cheers
You can put a delay between them.
Dear @Rakshith,
Please make use of below properties to acheive your goal.
- Use verify expression in TypeInto which with auto retry.
- Introduce delay between key strokes of TypeInto activity.
- Activate HardwareEvent/Chromium API Input method of the TypeInto activity.
Snap for reference:
HappY Automation 
Br,
NikZ