3 Replies Latest reply: May 15, 2014 10:05 AM by Ron_b _ RSS

    Lsplit MM/DD/YYYY field

    Ron_b _

      I want to split a trapped field containing a mm/dd/yyyy date into two parts grabbing just the MM and the YYYY separately.  This would appear to be a simple Lsplit or Rsplit function but I keep getting an 'operand types' error message when attempting to define my formula.  My formula is simply:

       

      LSplit(RecallDate,3,"/",1)

      /CODE

       

      where RecallDate is the trapped date field that I want to split.  What am I doing incorrectly? 

      Thanks.