I am hoping that someone can help me with a problem that I am having in BOBJ 4.3 IDT with a Derived Table.
I am using the following syntax to build the derived table:
WHERE [Date] = @Variable(‘Select As of Date’)
This specific statement produces the following error (the statement above is definitely the problem b/c it works fine when I hard-code a date):
[Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string.
I have tried to get around it by using CAST and TO_DATE, but neither is working. Because the SQL does not validate, I cannot join this derived table to my other tables (in version 4.1, the same error comes up, but Derived Table allows a join to it – so this appears to be a 4.3 “bug”).
If anyone can advise of help me on this, I would greatly appreciate it! Thanks in advance!