Hi,
How do I use CurrentDate in the query?
Thanks
tendulkar (BOB member since 2004-03-15)
Hi,
How do I use CurrentDate in the query?
Thanks
tendulkar (BOB member since 2004-03-15)
I would suggest that you have date object (sysdate) created as a universe object so that you can select it when creating a report. You have to select a table to use when creating this object.
Randy Jones (BOB member since 2002-08-19)
I think you should not attach any table to sysdate object as it will pull that table in the query unneccessarily.
You should create a object with sysdata in the select box. and donโt assign any table to it.
This will give parse while parsing the object but it will work when used in the query.
If you want to assign some table to it then assign dual table.
Hope it helps!
JaiGupta (BOB member since 2002-09-12)