Current Week-4

[#1]

Hi

I need a week,which will be current week minus 4 week.How to achieve this in UI.

Ex:My Current Week: 2013 W05

Expected Week is:(Current week-4) ie) 2013W01.

How to achieve this.Please help me.

Thanks,

Gowthami

[santharubban]

Gowthami

try this

weekname(WeekStart(date(WeekName(Today())-24)))

or

weekname(date(WeekName(Today())-24))

[ashwanin]

Hi Gowathami,

In your input box, how 2014 WK4 is coming?

Is it  by some calculation or direct from QVD/File?

Also create new button and check is this formula working in this or not :  =Week(today())-1