Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 07, 2015 at 05:45 PM

    I think you can use date generation transform. Not sure its part of 3.1 check this link.

    Date Generation Transform - Enterprise Information Management - SCN Wiki

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 04:38 PM

    Hi

    Are you trying to load dates for a full month into a table with 12:00:00 as the time pat of the date?

    Can you please give a bit more detail on what you are going to load? Just dates??? or dates with other columns?? .....

    kind regards ¨

    Raghu

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your reply Raghu,

      Yes I'm trying to load full months date into a table with 12:00:00 as time stamp. I will be using to this date column to compare with another table date column to extract the data, dates with other columns

      Thanks.

  • avatar image
    Former Member
    Jan 07, 2015 at 05:26 PM

    If you want to generate rows with subsequent dates , then you can achieve that with previous_row_value() function.Set your first row date as 2014/10/01 and for the next row use previous_row_value() and increment the date by 1 and so on.Have a look at this.

    Access to Previous Row Values - Enterprise Information Management - SCN Wiki

    Add comment
    10|10000 characters needed characters exceeded