text object auto update

[#1]

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?

[#2]

Alex,

With the = sign

= max({1} Date)

Fabrice

[Anonymous · Accepted solution]

Alex

Try this expression in your text box :

     ='Revenues for WC ' & date(weekstart(today() -7))

Best Regards,     Bill

[SunilChauhan]

='Revenues for '&weekstart(today())

try this hope this helps

[#5]

perfect, thanks