Date format for graph

[bhp]

Does anyone know how to format a date field in a formula as I need to use the date in a graph. I have a date field in this format: '2/18/2004' that I need to make into 'Feb 18, 2004'
Thanks for any help

 

[pgtek]

Hi

you can select that field and right click format and change it
to what you want it to be.

cheers



pgtek

 

[bhp]

No not in a graph, I have now had to convert the field into a text field using a formulae and then display the formulae in the graph, many thanks for your reply! - James

 

[Wallie12]

It is not the cleanest, but it works.

"20" + (Totext(Year({Command_1.DIS_OPENDATE}))[4 to 5]) +
'-' + Totext(MonthName ((Month ({Command_1.DIS_OPENDATE})), True))

Wallie12

 

[Reebo99]

Wallie,

YOu can format the dispay of ToText like :

ToText({Command_1.DIS_OPENDATE},"yyyy-MMM")

This would give you, for example, 2004-Jan which I think your formula is producing.

Reebo
UK

Please Note - Due to current economic forcast and budget constraints, the light at the end of the tunnel has been switched off. Thank you for your cooperation.

 

[ajakeway]

I'm trying to do exactly the same thing, but in CR 8 it thinks that the formula result should be treated as text so the graph is sorted alphabetically rather than by month. So the order looks like:

April-04
August-04
December-04
February-04
etc

Is there a way around this? The only thing I thought of was to prepend a number to force the order (eg 01-April 04, 02-May 04, etc). Any ideas? TIA,

Alex

 

[lbass]

If you use a date field (of date datatype) as your "on change of" field and then highlight it in the chart expert and choose "Order", you could set it to print on change of month. This would result in the correct display, but with labels like 01/2004, 02/2004, etc.

If you must use text for the date field, then highlight it, go to "order" and choose "Specified Order" and use the dropdown list to order the months chronologically.

-LB