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

    Expression ....  Show me the date

    Phil Speight



      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