Filtering excel file by date (eg 2/10-4/10) but encounter Read Range: Not a legal OleAut date

Build Studio
#1

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

#2

Hello can anyone help? Thx u

#3

@Lew_Sin_Tat

Check as below for OLE Date for your reference
Tutorial : Convert Number to Date Format

Follow Link

Hope this helps you

Thanks

#4

Thanks for the link so I will have to change the date to the correct type before inserting the read ?

#5

@Lew_Sin_Tat

Yes, the date should be in correct format

Hope this helps you

Thanks

#6

I realise if the number of rows of data is capped to 250 there won’t be error any idea why.

#7

@Lew_Sin_Tat

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

#8

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