How to get every friday date in the year in Webi

[saravanan_lakshmikanthan]

Hi Expert,

My requirement is get every friday dates in the year in webi

for eg.. 29 Mar 2013, 05 Apr 2013,.....

Thanks,

Saravanan L

+91 988 464 3843

[harshil_joshi · Accepted solution]

Please close your discussion with Correct Answer/ Helpful Answer.

Thanks & Regards.

[saravanan_lakshmikanthan · Accepted solution]

Hi Joshi...

Thanks for your help answer..

Rgs

Saravanan

[harshil_joshi]

Dear Saravanan,

Please follow the steps:

Make a variable named Friday=DayNumberOfWeek([Your Transaction Date])

Now put this variable against your transaction date, you will date like this result

Marked with Green are your Fridays you can filter them and can get result attached below

Thanks & Regards.

[Former Member]

You post this question in wrong place.

for webi related check the below link

http://scn.sap.com/community/businessobjects-web-intelligence

for you question create a variable.. Friday  =DayNumberOfWeek([Calendar Date])

then use report filter FRIDAY = 5

regards,

Sree