Displaying a date in an expression label

[#1]

Hello,

Probably a very simple answer to this but I cannot get it to work.

I have various set analysis expressions to show totals for last full calendar week and the previous week to that via the code

_CurrentWeek = {1} or _PriorWeek = {1} etc

I also have a Week End date loaded to show the Sunday of the relevant week i.e currently this shows  where _CurrentWeek = {1}, the Week End date is  13/10/2013

where _PriorWeek = {1}, the Week End date is 06/10/2013 etc

I would like to have the expression label to show 'Current Week' & 13/10/2013 or 'Week -1' & 06/10/2013

How can I do this please/

Thanks,

[CELAMBARASAN]

May be something like this

='Current Week' & WeekEnd(Max({<_CurrentWeek = {1}>} Date))

='Week -1' & WeekEnd(Max({<_PriorWeek = {1}>} Date))

or If you have WeekEndDate Field

='Current Week' & Date(Max({<_CurrentWeek = {1}>} WeekEndDate), 'DD/MM/YYYY')

='Week -1' & Date(Max({<_PriorWeek = {1}>} WeekEndDate), 'DD/MM/YYYY')