Calendar Date Formatting

[adoremars]

Hi Team,

I need your quick help.

I have a database query subject in framework manager, with a data item Calendar Date with data type as Date Time.
This is how the Calendar date looks by default March 10, 2013 12:00:00 AM.

I need to have only date in this column and want to do this without using any sort of conversion functions.

I tried to format it to Date through the format property, which will enable when I click on the data item. But no luck.

Appreciate your prompt help to do this.

thanks..

[adoremars]

Hi Team,

Can anyone help me on this please?

thanks a ton..

[Satheesh]

Hi,


Date & Time is at Database Level so without using proper function you can't get.


You can use cast() function.
Cast(Calender Date,Date)

[adoremars]

Hi,

I should not use any functions.

The issue is fixed now. Used the Cognos formatting option at FM level.

thanks..

[Satheesh]

Hi,


Can u tell step wise....How is it..