Hi All,
I have a field that is supposed to be a date field however I think its just a normal string.
I am trying to workout how I can turn it into a date so I can use it in my Record selection formula, I had some ideas but I don't understand how to use the split function.
my date field is in the following format as a string DD-MMM-YYYY.
this is how I imagine the formula would go... but its wrong any ideas?
Split({Date Field}) = array
Date(array(1),array(2),array(3))