Current date in this format mmddyy ASAP pls

[krishdw85]

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

[MFGF]

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.

[krishdw85]

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

[krishdw85]

oops i got this

'200$COL'+to_char({sysdate},'mmddyy')+110

[MFGF]

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.