How to Auto-Schedule with a Dynamic Date Parameter

[MarkP]

@JoeyB99

Hi everybody, it’s me again.

I do not have access to create an object for a universe, or whatever Joe is suggesting.

I am using version 4.1.

I have a relatively simple report and I want the output to always provide forecasted data based on the date field, such that it is >= today.

What options do I have? Is there something I can do with the report filter and simply omit any date criteria in the query filter?

Speak to your universe designer - they will be able to create the objects in the universe for you, as per the objects in this topic:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…