3 Replies Latest reply: Mar 2, 2016 9:44 AM by Phil Speight RSS

    Expression ....  Show me the date

    Phil Speight

      Hi

       

      I have an expression that I am putting in a text box, but it shows the number not the date.  The expression is :

       

      =min(aggr(if(fabs(Publish_Date-date(vToday)) = vMinDate,Publish_Date), Publish_Date))

       

      It currently outputs

       

      The next publish date is : 42430.

       

      How do I get it to show

       

      The next publish date is : 01/03/2016



      I have attached the example.



      Many thanks




      Phil