Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a text object which reads 'Revenues for WC 17/2/14'
The date displayed is the Monday of the week before, which I have to manually update each week.
How can I get the date part of the text box to automatically update for me each week?
Alex
Try this expression in your text box :
='Revenues for WC ' & date(weekstart(today() -7))
Best Regards, Bill
Alex,
With the = sign
= max({1} Date)
Fabrice
Alex
Try this expression in your text box :
='Revenues for WC ' & date(weekstart(today() -7))
Best Regards, Bill
='Revenues for '&weekstart(today())
try this hope this helps
perfect, thanks