This content has been marked as final. Show 4 replies
Thanks for the quick reply...
I want to continue by next question on top of the TIMESTAMPDIFF function....
TIMESTAMPDIFF(SQL_TSI_DAY, "Bank Transactions - Payor Aging".AccountingDate, TIMESTAMP '2010-06-02 00:00:00')
how can I pass this part of the value from the Dashboard Prompt. I knew that the dashboard prompt can only be created on the presentation column. I can't put any date column in my datawarehouse datamodel as there is already one. I looking if there any other way of passing the second date value from the dashboard prompt.
Thanks in Advance