Skip to Content
0
Former Member
Apr 07, 2010 at 06:31 AM

Formula help String to Date

656 Views

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))