Modifying existing input table for output table

cloveretluseruser

• April 20, 2017 00:00

• Answered

Follow

Hi All,

I would like to take this table(Table1) which I have in my database:

Table1

Date
01-01-2017
01-02-2017
01-03-2017

and create a new table(Table2) to my database with the following:

Table2

Start Date End Date
01-01-1990 01-01-2017
01-01-2017 01-02-2017
01-02-2017 01-03-2017
01-03-2017 Current Date

Please help. Is there any way to do it?

• 

  svecp

  • April 25, 2017 14:41

  0

  Comment actions Permalink

  Yes, solution might look like the one attached. In case incoming data are sorted, you can lose the ExtSort component.

  • ranges.grf

Please sign in to leave a comment.