Select only week ending dates

[#1]

Hi,

I have a date dimension from which i want to only select the Friday dates? Can someone give me an expression to do this?

I.e. I have the following:

Date
29/11/2013
06/12/2013
13/12/2013
01/12/2013
02/12/2013
27/11/2013

I need:

expression(date)
29/11/2013
06/12/2013
13/12/2013

thanks

[#2 · Accepted solution]

use the Weekday() function.

Fridays:

LOAD Date

FROM

FROM [..\dates.qvd] (qvd)

Where Weekday(Date)=5;

Hope this helps

[MayilVahanan]

Hi

Try like this

Load

If(WeekDay(Date)='Fri', 1, 0) AS Flag,

*

From Tablename;

In Expression, try like this

=Sum({<Flag = {1}>} Sales)

[#4]

Hi

PFA hope this will help you