DavidOSullivan94
New Member
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:
Left([SortedCollectionCSVDate.InteractionDateTime], 11) = "[InteractionDateTime] ='" & [Today] & "'"
- The 11th index is where the space is.
- I've also tried to use a wildcard i.e "filter using the date 25/01/2020*" but to no avail.
Has anyone got any pointers or direction?
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:
Left([SortedCollectionCSVDate.InteractionDateTime], 11) = "[InteractionDateTime] ='" & [Today] & "'"
- The 11th index is where the space is.
- I've also tried to use a wildcard i.e "filter using the date 25/01/2020*" but to no avail.
Has anyone got any pointers or direction?