Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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)
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.