5 Replies Latest reply: Nov 12, 2015 10:02 AM by Henric Cronström RSS

    Change date format

    Kumar Pramod

      HI all,

       

      I am using the below expression to change the date format but it's not changing.

       

      yearend(max(CanonicalDate,'MM-DD-YYYY'),-1)

       

      I need the count till last year end. in my db the date format is 'MM-DD-YYYY' so i am using above expression but it's not changing.

       

      it's printing in 'MM/DD/YYYY' when i print in text box

      Thanks,

      Pramod