Post reply

String funtion to extract 2 digits from the middle?

  • December 19, 2012 at 2:14 pm

    #286368

    I have a date field which is in this format YYYYMMDD, I'm trying to convert it into YYYY/MM/DD.

    Though I was successful in extracting the first 4 digits using

    left(Fields!DATE.Value,4)+"/"+right(Fields!DATE.Value,2) ,

    How to extract the month MM from the yyyymmdd

    Thx

    Sm

  • December 19, 2012 at 2:27 pm

    #1570313

    got it

    =left(Fields!DATE.Value,4)+"/"+mid(Fields!DATE.Value,5,2)+"/"+right(Fields!DATE.Value,2)

    give me the result in this format YYYY/MM/DD 🙂

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply