Help with date format!

[actcognosuser]

I have a date in my crosstab.When I change the format to show only months,
nothing is changing in my report.The format is PDF.The date still appears with default format.

[Nuffsaid]

Hi,

In your crosstab row or column select your date field, then in the Properties section change the "Text Source - Source Type" from Member Caption to Data Item Value. You should then be able to format however you wish.


Nuffsaid.

[actcognosuser]

I changed the source type to Data item value.It did not change.It still shows the default format.
I am applying some rules to render the column date.

Report  displays  dates for month until march of 2010 ,for last years date the column name will be previous year.Is it because of this if then condition that my formatting is not applied.

[Nuffsaid]

Hi,

Based on the info provided in your first post I thought you were just having difficulty formatting a date field.

I am applying some rules to render the column date

What rules would these be ??

Is it because of this if then condition that my formatting is not applied.

More than likely, but we would need to know what the condition is in order to offer up any help.


Nuffsaid.

[jon]

I changed the source type to Data item value.It did not change.It still shows the default format.
I am applying some rules to render the column date.

Report  displays  dates for month until march of 2010 ,for last years date the column name will be previous year.Is it because of this if then condition that my formatting is not applied.

After you change it to Data Item Value, go to Data Format, change it to date and set the date style in properties. It'll work.

[actcognosuser]

Hi Nuff,
              My rule is if date = maximum(date) then 'Current' else (date)

How do I apply formatting to display only the month for my date filed.

Thanks in advance!

[Nuffsaid]

Hi,

First off, if "Date" is a true date/time field you're mixing data types in your IF statement. This is a no no........

Thinking this solution will be database specific. This works with Oracle however;

if([Date]=maximum([Date]for report))
then('Current')
else (to_char([Date],'MON'))


Nuffsaid.

[actcognosuser]

Hi Nuff,
              I did use char(date).How do I get it to display month for the date?

[Nuffsaid]

Hey,

to_char([Date],'MON') will display the abbreviated month.

Google the function if you're still unsure....


Nuffsaid.