Hi ,
I may be posing the wrong question here or I may not be asking it correctly.
I have a collection, there is a heading "InteractionDateTime" with the data types like (27/01/2020 09:33)
I'm looking to filter the collection by the first 10/11 characters or "27/01/2020 "
I've tried to split...
Hi,
Thanks for your reply.
I've tried to filter the date by today's date and it has worked in the past.
If for instance, I am trying to sort the date by the a previous date, shall I replace 'Today()' with a data Item [DateIAmLookingFor]
Hi,
I've read a csv file as a collection and I'm trying to mimic the action of a macro in blue prism, I have sorted the data accordingly and I am now looking to filter the data point (which happens to be datetime) by the " " space separating the date and time.
I have this so far...
Fixed.
Solution:
Make sure to put all parameters inside the functions parentheses.
Code below will filter the range highlighted, by the 10th column with the constraint of the date.
To make the VB dynamic, include input parameters from the process.
===...
I've rectified the filtering error but the issue is now 'End of statement expected '
The code has changed slightly to as follows;
================================
GetInstance(handle).Range("$A$1:$X$114506"). _
AutoFilter(Field:=10), _
Criteria1:="27/01/2020" _...
Hi,
The Snippet runs perfectly in excel but when pasted into the Code section of the Code box properties; it throws an error.
It requires the 'method argument' to be in parentheses. This is unusual as the VB syntax doesn't follow this requirement.
======...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.