It is fairly simple but excel date sorting not working as expected, so it made me to seek help from you experts.
There are 3 web pages with tabular data having a due date column in DD/MM/YYYY 12:00:00 AM format (time part is always fixed), now bot to extract all 3 web pages data and create separate sheets in one excel, merge all 3 sheets into one sheet and sort the data on due date ascending order, the issue is when bot extract the data and create an excel sheet, this date value is not consistent, for few items it removes time and for few other time value stays.
I think it is excel issue as bot extract data correctly, is there any way I can keep this date value consistent throughout the process?
I hope i made the issue clear, please do let me know if you need additional details, besides following screenshots are to support
Due date on webpage 1
Now when above data is copied in excel
Same thins is happening with other webpages data too and as a result final sorted data is not in accurate order.
Any input/thoughts will be helpful.