Skip to Content
0
Former Member
Jan 26, 2011 at 07:51 PM

Derived table with Date Range

73 Views

Hello,

I like to create a derived table in the Universe with Date Range from year 2001 to year 2010 and select only week end (saturdays) dates.

For example:

2001/1/6

2001/1/13

2001/1/20

2001/1/27

2001/2/3

...

2010/12/25

-


However I don't have any table/column to get the values. I need this to support the user prompt and will be used for display purposes only. Any ideas about the above query?

Thanks in advance

AK