Greetings.
This question is still open today, perhaps it was overlooked or just lost in the volumes. Please return to this question to update it with comments if more information is needed to get your solution. If you've been helped by the participating expert(s), you may just convert their comment to the accepted answer and then grade and close. If an answer has ever been proposed you may not have this option to accept the comment as answer, if that is the case, ask the specific expert you wish to award to post an answer. This benefits others who then search our PAQ for just this solution, and rewards the experts who have provided information. A win/win scenario.
If you wish to award multiple participants, you can do so by creating a zero point question in the Community Support topic area, include this link and tell them which experts you'd like to award what amounts. If you'd like to delete this question, use the same process as above, but explain why you think it should be deleted. Here is the Community Support link: http://www.experts-exchang
You can always click on your profile to see all your open questions, in the event you also have other open items to be resolved. If your number of Questions Asked is not equal to the number of Answers Graded, choose to VIEW question history, and you'll quickly be able to navigate to your open items to close them as well.
I've had excellent help from experts-exchange through the years and find the real key to getting what I need is to remain active in all my questions, responding with results to suggestions until my solution is found, and recommend that highly.
Thank you very much for your responsiveness, it is very much appreciated.
":0) Asta
P.S. Some of the older questions from last year are not in the proper comment date order, and Engineering has been advised.
Main Topics
Browse All Topics
by: kenhamadyPosted on 2000-11-04 at 10:17:49ID: 5095103
Typically you can click on any date field and override the default format.
However, up through version 6, the Crosstab heading can't be formatted like other date fields. It is treated as a string taking its format from the default settings in options.
Starting with V7 you could format the date in the heading of a cross-tab like other fields.
In V6 you could create a nested if-then-else and generate the string name based on the month. To get them to sort correctly you have to put a number of spaces ahead of the values.
If Month({Orders.Order Date}) = 1 then " Jan" else
If Month({Orders.Order Date}) = 2 then " Feb" else
If Month({Orders.Order Date}) = 3 then " Mar" else
If Month({Orders.Order Date}) = 4 then " April" else
If Month({Orders.Order Date}) = 5 then " May" else
If Month({Orders.Order Date}) = 6 then " Jun" else
If Month({Orders.Order Date}) = 7 then " Jul" else
If Month({Orders.Order Date}) = 8 then " Aug" else
If Month({Orders.Order Date}) = 9 then " Sep" else
If Month({Orders.Order Date}) =10 then " Oct" else
If Month({Orders.Order Date}) =11 then " Nov" else
"Dec"
If you right justify the field you won't be able to tell.
Maybe someone knows a less kludgy approach. Or, you could always upgrade to V7 or V8.