will take first part as month, so July would result
We can do without splitting:
But we recommend inspecting the data table and cross-check how the date strings are stored within the data table as described here:
[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum
DateTime is a structure and we will not touch the internal structure