How to use a defined detail variable in a condition

[smooveb]

Specifically, I wish to formulate a condition which compares a posting date with the Business Objects internal CurrentDate() field minus 30.

I can define the variable currentdate - 30, but don't know how to use this variable to stipulate a condition afterwards. Any info out there?

This would enable me to only take info from the last 30 days. Thanks!

Barrett

 

[BobWard]

Not sure i fully understand your problem. Can your not do something like Posting Date >= currentdate -30 ??

 

[ShyamRewaskar]

define a condition at designer level
say condition "prv_mpnth" and write
"post date>=(currentdate -30)"

The current date function is diff for diff database.. u'll ve to find out.

and use this condition in the where clause of bo dataprovider.

 

[smooveb]

Well, I could probably figure out how to enter those statements in sequel. However, I can't seem to write to the SQL from the query window - instead it only brings up the SQL Viewer.

If I do not go through SQL, the conditions section of my query window will only allow me to use objects already in the universe. And we do not have an object equivalent to currentdate()-30. And unfortunately, I don't have design access to the universe.

Thanks for reading this
Barrett