As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
All, I am trying to get current date from system.I used TODAY and modify them to get current date.Also i used couple of other options that i got from forum. DT_TODAY/YYMD = '&YYMD'; TODAY/YYMD='&DATEYYMD'; I used DEFINE for all the above. But when i am trying to pull them in to the report i am getting the following error. "(FOC1175) NO REFERENCE TO FIELD DATA NO HTML OUTPUT" I tried COMPUTE also. But same error came. Any idea what is the issue?I am using Dev Studio 7.1.6.Do i need to activate any system options to enable these operations?
Alan, It didnt work. I gave the same way as you told, i gave a field name from the DB which has some date value.Still it didnt work. I am using this system date as a filter in the report.I also noticed if i pull this DEFINEd column with some filter condition then it works.But for me this DEFINEd column should act as a filter. Any other inputs will be greatful. Regards R.Prasanna