If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Running List of Dates

Started by kazanec, 11 Dec 2007 02:37:30 PM

Previous topic - Next topic

kazanec

Is there a way to generate a list of dates between a certain range? For instance, show me all dates between January 1, 2001 and today? I'm trying to a create a Date data source for use in Transformer.

almeids

For small, fixed size record sets you could probably play games with UNIONs and your database's dummy table (e.g. DUAL in Oracle), but realistically you're pretty much going to need something in a real table...either one populated with all the potential dates you would want in your ranges, or one containing records with sequential integers which themselves have a range as large as the largest you would want for your dates (so you could calculate your dates as an offset to the start date).

kazanec

Thanks. I ended up creating a procedure to update a table with a series of dates. Works great.