9 Replies Latest reply: Sep 21, 2015 7:31 AM by Sasidhar Parupudi RSS

    Dates

    nareshthavidishetty nareshthavidishetty

      Hi,

      I created a composite key with fields as Enterdate &'_'& Centernum as %key and then i drop the field EnterDate,

      but i need to use the date field in the front end expression may i know how to fetch only date field from %key.

       

      I tried this ...date(date#(left(%key,10),'MM/DD/YY')