Data Extraction with Date&Time not working as expected

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
image
Now when above data is copied in excel
image
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.

@ramvashista85
Try this
DateTimeFormat.zip (20.0 KB)

Thank you @KarunaD for your response, appreciate, i tried this before but didnt work, tried it again but unfortunately didnt work too. problem is while creating data in excel, date time converts to MM/DD/YYYY. please refer following-
Data extracted from webpage

image

Data saved in excel
image

Any other thoughts please?

  1. Try both, the standalone “write range” as well as the “write range” inside the excel scope. The behavior is different.

  2. If you’re using an excel template to fill the data, make sure you have the correct date formatting in the column

1 Like

@ramvashista85

check below for your reference

also for difference

Hope this may help you

Thanks

@ramvashista85
You need to set the Date and Time format in excel
Date Column – Right Click – Format Cell and refer the screen shot

Then try with attached sample workflow it will work.

Thank you @nameless, using discrete write range did the trick.
Never imagined different behavior of same activity when used standalone and inside excel scope.

I managed to solve this.
The issue was with excel, date and time in excel is quite funny to work with. As I mentioned in problem statement, date values extracted from webpage are not consistent, for some of it comes with dd/MM/yyyy and for other MM/dd/yyyy, for some items time is truncated.
So the challenge was to keep the data consistent. Please let me know if someone need to know the solution.