Displaying last week date in text object

[#1]

Hi Team,

Hope all are doing good.

I have a requirement like in a text object I have to  display last week Friday date dynamically. i.e for this week it should be previous week Friday date.( I guess we have to do this with today())

ex:if we see today it should be 03/07/2015

if we see in next week it should be 10/07/15.

Please help on this.

Thanks

Nani.

[MayilVahanan · Accepted solution]

Hi

Try like this

Date(Floor(WeekEnd(Today()) - 9))

[#3]

Thanks Ramasamy. Its working fine.