Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Try this:
='Next Publish Date '& Date(min(aggr(if(fabs(Publish_Date-date(vToday)) = vMinDate,Publish_Date), Publish_Date)), 'DD/MM/YYYY')
Perfect, Thanks