Date(10/21/2008) to Day (10/21)

[rama_krishna51]

hi all,

We have a requirement where we need to display the Day (MM/DD) using a Date MM/DD/YYYY) and we need to do this at query level.

how can we achieve this..

thanks,

Rk

[former_member181964 · Accepted solution]

Hi,

This you can do it using Custome Exit code in CMOD.

Create Formula Variable as a customer exit and try.

Thanks

Reddy

[former_member205352]

Query level I am not sure, even if we use formula variable it can only come under key figures not characteristics.

For your case may be you can do this at workbook level with simple VB coding.

or

You need to have seperate characteristic in infoprovider for which you can populate in update routine.

Hope this helps.

Edited by: Praveen G on Oct 16, 2008 7:52 AM

[rama_krishna51]

thanks for your replies,

i was trying to create a formula variable with replacement path, i was successful but the day is displayed as 301 for 03/01 or 1205 for 12/05,

can you suggest me how to get the desired output ie 03/01 or 12/05.

thanks in advance.

Rk

[Former Member]

Hi Rk,

I have a similar problem. My input is dar/mth/year and the report output is month/year. We wnat to do it at the report level.

Any ideas on how to go about it.

Regards

Krishna

[Former Member]

Hi Rk,

I have a similar problem. My input is dar/mth/year and the report output is month/year. We wnat to do it at the report level.

Any ideas on how to go about it.

Regards

Krishna

[former_member194802]

Hi Krishna,

had you tried to set Regional Settings.

Control Panel-> Regional settings

set the date format.

this will reflect on your reports.

Regards

Vivek