Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
='Tickets '& Status &' '&today()-30 &' - '&today() is the expression I gave in text box
the required output is Tickets Status 14-01-2017 - 12-02-2017
but I am getting - 12-02-2017
require help on this
Try this
='Tickets '& Status &' '& (Today() - 30) &' - '& Today()
='Tickets Status' &' '& Date(Today() - 30) &' - '& Date(Today())
Try below expression.
='Tickets '& Date(Today() - 30,'DD-MM-YYYY') &' - '& Date(Today(),'DD-MM-YYYY')