LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  Creating a date list

    Employee
    Posted 05-04-2016 07:46

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: khopkins

    Hello,

    I am trying to use a loop to create a complete list of dates between a start date and an end date that is in one record.
    So for example
    StartDate EndDate
    30/12/2013 01/01/2016
    from this single record i need a Cartesian list of all the dates between and including those dates and i am struggling to get it to work.

    Can anyone give me some pointers please?

    Regards,

    Keith


  • 2.  RE: Creating a date list

    Employee
    Posted 05-04-2016 07:51

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    Take a look at: https://infogix.zendesk.com/hc/en-us/community/posts/360051796473


  • 3.  RE: Creating a date list

    Employee
    Posted 05-04-2016 08:23

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: khopkins

    Thanks ryeh that works a treat as i was forgetting the output after the loop


  • 4.  RE: Creating a date list

    Employee
    Posted 05-05-2016 05:32

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: awilliams1024

    Hi,

    you may be also interested in using one of the new 'accelerators' that are available to users of LAE 6.1 / LAE 6.0 who have installed LAL 6.1.44.0 / LAL 6.0.44.0.

    The 'Master Calendar Creator' accelerator enables you to generate create a date list. It also generates fields containing the associated date-related elements of each date value, namely: Year, Quarter, Month, Week, Day and Weekday.

    GenerateDates_Accelerator.brg


    The accelerators can be made visible in the node palette for the current data flow by adding the accelerators as a base library:

    In the BRE menu click on Graph -> Edit Base Libraries...
    Then click on the 'New' icon in the Base Libraries dialogue panel
    Type 'accelerators' into the new empty row (without the quotes) and click OK
    The accelerators should now be visible in the different categories of the palette.

    To add the accelerators to the palette for all data flows perform the following:

    In the BRE menu click on Tools -> Preferences
    In the BRE Preferences panel click on the 'Libraries' tab
    Click on the 'New' icon in the 'Default Base Libraries' pane
    Overwrite the 'new' library name with 'accelerators' (without the quotes)
    Click OK
    Close BRE and reopen it - the accelerators should now be visible in the palette.

    Should you want to remove the accelerators from the palette, follow the initial steps you used to add them for the current data flow or all data flows and when the list of base libraries is displayed select the accelerator entry and click on the 'Delete' icon and click OK

    Best regards,
    Adrian