Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Generate date

Hi All,

I'm using BODI 3.1 and Oracle 11g as my backend, how do I generate date from start of month to end of month in designer as specified below

DATE

'2014/10/01 12:00:00' 

                  ---

                  --- 

'2014/10/31 12:00:00'

Any help would be greatly appreciated.

Thanks.

Former Member
replied

to_char( Date_Generation.DI_GENERATED_DATE,'YYYY/MM/DD)||' 12:00:00'

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question