I am writing a bot that download an excel file (has a date column between 1/10-10/10) from my company intranet to my local folder and will subsequently filter base on the date column (eg 2/10-4/10) . The first step to copy the file to my local folder is successful but the next step to READ from a particular sheet with the “date” column yields this “ Read Range: Not a legal OleAut date”. I am stuck and cannot move on. Any help is appreciated thx u
Hello can anyone help? Thx u
Check as below for OLE Date for your reference
Tutorial : Convert Number to Date Format - #2 by system
Follow Link
Hope this helps you
Thanks
Thanks for the link so I will have to change the date to the correct type before inserting the read ?
I realise if the number of rows of data is capped to 250 there won’t be error any idea why.
Can you share more insight to your issue
Data cap may not be the issue i hope
If you can share the excel file where you are getting issue that we can check
Thanks
Ok I manage to solve this as the format is not correct for 1 row… now my new issue is I want to filter by today +1 to today +3 days…l try using filter data table but can’t be done it seems thx