The problem Im having is that when the prompt is used to filter out dates while using a universe, which is using a MSSQL database, I am getting the following error message: [Microsoft][ODBC SQL Server Driver][SQL Server] The conversion of varchar data type to a datetime data type resulted in an out-of-range value
When I tried using the same prompt functionality while using a universe that is using an Oracle database it worked ok with no issues.
You help in this would be greatly appreciated, since I am really stuck with this issue.
To help you out, please post the data type of the column from the database (I assume it’s varchar) and the code used for the prompt. Also, what is the data type of the column in the universe?
First of all I would like to thank you for your time.
Ive check the columns in question:
a) in the database they are defined as datetime data types,
b) on the universe they are defined as date data types
c) the code used for the prompt is @prompt(‘Enter Start Date:’,‘D’,Mono,Free,Persistent,User:0)