Hi folks,
Environment cognos 8.4 & oracle 10g
i would like to appreciate if any one provide the urgent calculations for me
i want the current system date as in this format mmddyy.
Please share the exact calculations which ll be helpful .
Thx in adv
Hi,
Drag a query calculation into your report. For the expression, use
current_date
Select the calculated item in your report, and go to the Data Format property. Set the Format Type to be Date, set the Date Style to Short and set the Date Ordering to Month, Day, Year.
MF.
Thanks for the answer
In the date column that means in the same calculation i am doing concatation also
that means 200$COLmmddyy(Currentdate)110
Here i want to concat 200$COL with currentdate and 110.
Can you please tell me ASAP
oops i got this
'200$COL'+to_char({sysdate},'mmddyy')+110
As an alternative, leave the query calculation returning just mmddyy, unlock the report structure and drag text items before and after the date value in the column and enter the preceding and following pieces as text.
Regards,
MF.