Print Page - Calendar Date Formatting

Title: Calendar Date Formatting
Post by: adoremars on 05 Aug 2013 08:06:53 AM

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..

Title: Re: Calendar Date Formatting
Post by: adoremars on 06 Aug 2013 01:24:09 AM

Hi Team,

Can anyone help me on this please?

thanks a ton..

Title: Re: Calendar Date Formatting
Post by: Satheesh on 06 Aug 2013 02:04:41 AM

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)

Title: Re: Calendar Date Formatting
Post by: adoremars on 06 Aug 2013 04:21:58 AM

Hi,

I should not use any functions.

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

thanks..

Title: Re: Calendar Date Formatting
Post by: Satheesh on 06 Aug 2013 05:18:18 AM

Hi,

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: adoremars on 05 Aug 2013 08:06:53 AM