Rolling Objects

[Former Member]

Hi Guys,

I am new to designing universe and want to design filters wherein from a specific date (ex 1st July 2011) it will help me to filter data till the current sysdate. Please can you assist if it will be possible to harcd code the stating date.

Best Regards,

Shazin

[Former Member · Accepted solution]

What is your data source?

If it is SQL Server, then yes, it's certainly possible.

Create an object, call it 1st July 2011 as:

'2011-07-01'

Note that it will not parse

Create an object, call it Today as:

cast(convert(char(10),getdate(),23) as datetime)

Again it will not parse.

In your report, you can now bring in whatever date you want to filter by (sales date, order date, etc) and then choose between, then select the 1st July 2011 object, then select the Today object so that your condition now reads something like:

"Sales Date between 1st July 2011 and Today"

Are you sure you want it for 1st July 2011 forever or just for this year?

For Oracle, your Today object would just be:

trunc(sysdate)

Your 1st July 2011 object would be:

to_date('2011/07/01', 'yyyy/mm/dd')

Edited by: Me map on Jul 22, 2011 10:44 AM - Added Oracle syntax