Month End Date

[Arthur1]

Hi,

Does anyone know how to create a Business Objects object that can always return the current Month end? Any help would be apprciated. Thank you.

 

[Sridharan]

Hi,

Do you want to return the Current Month or Current Months End Date????

Sri

 

[blom0344]

In ORACLE:

SELECT LAST_DAY(SYSDATE) FROM DUAL


T. Blom
Information analyst
tbl@shimano-eu.com

 

[blom0344]

Did not find a function yet in DB2 , but with calenderfile at hand it would be something like:

Select max(date) from calender,sysdummy where
month(current date) = month(date)

T. Blom
Information analyst
tbl@shimano-eu.com

 

[Arthur1]

Hi,

I am using Sybase. I want fro example if today is 06/04/2003 I want it to return 06/30/2003.

Any help would be appreciated.

 

[laknk123]

Try using

LastDayOfMonth(<System Date>) function of BO.

 

[naga5566]

If you need the last day of month in Bo instead of databse then create a variable/formulae using
=LastDayOfMonth(CurrentDate()).This gives you the last day of month.

vijay

 

[Arthur1]

I used the dateadd funtion of Sybase:

select convert(datetime,convert(char,dateadd(day, -1, dateadd(month, 1, dateadd(day,(-datepart(day,getdate())+1), getdate() ))),101))