Re: NumberFormat for dates not working

It's not an article, it's a newsgroup post with a similar issue.

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


"Sputnik" <id_hannah@xxxxxxxxxxx> wrote in message
news:1156280493.022592.240400@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Alvin,

I have looked at this article and it does not seem to help me.

This is what I am doing:

// Add the dates to the array
rgDates.Add(SqlData.GetDateTime(idxDate));

// Set the dates
Series.SetData(ChartDimensionsEnum.chDimCategories,
(int)ChartSpecialDataSourcesEnum.chDataLiteral,
rgDates.ToArray());

DateAxis.HasTitle = true;
DateAxis.NumberFormat = "MM/YYYY"

DateAxis.GroupingType = ChartAxisGroupingEnum.chAxisGroupingNone;
// DateAxis.GroupingType = ChartAxisGroupingEnum.chAxisGroupingAuto;

If I comment out the chAxisGroupingNone line and uncomment the line
below then the date formatting works and I have no idea why!

Ian

Ian Hannah wrote:
Alvin,

Do you mean this article:

Subject: How to display text in the format hh:mm for a category label?

Thanks

--
Ian H


"Ian Hannah" wrote:


Alvin,

Thanks for the reply. Unfortunately I have not managed to find the
article
that illustrates the workaround. Could you please give me the details
on the
link?

Thanks

--
Ian H


"Alvin Bruney [MVP]" wrote:

about 4 weeks ago, the issue was identified and a work around was
presented
in the newsgroup, please google for the solution

--
________________________
Warm regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
Professional VSTO.NET - Wrox/Wiley
The O.W.C. Black Book with .NET
www.lulu.com/owc, Amazon
Blog: http://www.msmvps.com/blogs/alvin
-------------------------------------------------------


"Ian Hannah" <IanHannah@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:80BEBDBE-4DEC-4028-9762-6A89AEF3B2DA@xxxxxxxxxxxxxxxx

I am using OWC10 for creating a chart in ASP.NET. I am suing data
read
from
a SQL Database and I am creating a Y axis and an X axis. The graph
is
displaying data read at a number of different dates over a date
range. The
x
axis is displaying the dates.

The problem I am having is that the date format is always
MM/DD/YYYY
regardless of how the NumberFormat is set i.e. dates are always in
US
format.
I have noticed that if I set the enumeration to either auto or
manual the
dates show in the correct format but the graph it wrong. If I set
it to
NumberFormatEnum.None then the graph is correct but the date format
is
wrong.

Does anyone know what I am doing wrong or is there a bug in setting
the
NumberFormat?

--
Ian H






.

Relevant Pages

  • Re: NumberFormat for dates not working
    ... refering to in this newsgroup. ... Ian Hannah wrote: ... Subject: How to display text in the format hh:mm for a category label? ... displaying data read at a number of different dates over a date ...
    (microsoft.public.office.developer.web.components)
  • Re: NumberFormat for dates not working
    ... Ian Hannah wrote: ... Subject: How to display text in the format hh:mm for a category label? ... a SQL Database and I am creating a Y axis and an X axis. ... dates show in the correct format but the graph it wrong. ...
    (microsoft.public.office.developer.web.components)
  • Re: NumberFormat for dates not working
    ... Subject: How to display text in the format hh:mm for a category label? ... "Ian Hannah" wrote: ... displaying data read at a number of different dates over a date range. ... dates show in the correct format but the graph it wrong. ...
    (microsoft.public.office.developer.web.components)
  • Re: Is there a fix for the print e-mail message in Plain Text form
    ... You know something Ian your solution has a lot of functionality besides what I asked about. ... Edit | Edit message I then selected the broken src image and DELETE. ... > Hi, George Hester; ... > options available depending on the message format, I went looking for a way ...
    (microsoft.public.outlook.general)
  • Re: NumberFormat for dates not working
    ... Warm regards, ... a SQL Database and I am creating a Y axis and an X axis. ... The problem I am having is that the date format is always MM/DD/YYYY ... dates show in the correct format but the graph it wrong. ...
    (microsoft.public.office.developer.web.components)