I have defined a domain that joins a few tables, and I'd like to limit the result set by applying a pre-filter that will only return recent (last 30 days) of records. I am using SQL server, so the SQL syntax would be: where MyTable.DateTimeField > getdate() - 30 If I add a pre-filter using an absolute date, I see the following in the exported domain XML: <filterString>MyTable.DateTimeField > ts'2014-11-11'</filterString> And this works fine. How can I change the absolute day to TODAY - 30? I have tried many combinations. I have looked at the semanticlayer.xml, but nothing seems to work. Any help would be grately appreciated! -Mark
