Expression .... Show me the date

[Anonymous]

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

[alexandros17 · Accepted solution]

use this expression

='Next Publish Date '&Date(min(aggr(if(fabs(Publish_Date-date(vToday)) = vMinDate,Publish_Date), Publish_Date)),'DD/MM/YYYY')

let me know

[sunny_talwar]

Try this:

='Next Publish Date '& Date(min(aggr(if(fabs(Publish_Date-date(vToday)) = vMinDate,Publish_Date), Publish_Date)), 'DD/MM/YYYY')

[Anonymous]

Perfect, Thanks