You could use the Position function to find the postion of the / character and then extract the digits to the left and right of this position, but Raybaudi showed me a better way some time back:
GetValue ( Substitute ( Contacts::ImportedDDayinfo ; "/" ; ¶ ) ; 1 )
returns the digits to the left of /
GetValue ( Substitute ( Contacts::ImportedDDayinfo ; "/" ; ¶ ) ; 2 )
returns the digits to the right.
Too fast Phil!!! Give a guy a chance!! I was just playing around with the Position Function.
Raybaudi seems to be a master at this kind of stuff.
Seriously though, thanks again :) I'll give it a whirl tomorrow, as I can't play anymore and have to get back to work.