Removing of particular period

[#1]

Hi All,

I have a qvd data in that the data as following.

Date

4/31/2011

5/30/2011

6/30/2011

7/31/2011

8/01/2011

8/02/2011

8/03/2011

........

........

8/30/2011

9/01/2011

9/02/2011

9/03/2011 etc

9/31/2011

I need the out put data in report level  like this only monthend data:

4/31/2011

5/30/2011

6/30/2011

7/30/2011

8/30/2011

9/31/2011

Plz find the attached sample data.

Thanks,

Ravi Teja

[MayilVahanan]

HI

Try like this

If(Num(Date) = Floor(MonthEnd(Date)), Date) As Date

or

Just use MonthEnd(Date) to convert the from date to MonthEnd date.

[#3]

hi

try to use distinct keyword, like below example.

in script--

load Distinct Date

from tablename;

******************************

in expression--

only(Distinct Date)

or try this

sum(Distinct Date)

[#4]

Thanks both...But when am using the monthend(date) it showing actual month end date(calender date) instead of date having date filed in qvd level.

Plz find the same

Thanks,

Ravi Teja.