C1 Community

I am creating a report with an embedded C1Chart.

I am creating a bar chart using a DateTime variable from SQL Server as one axis. If I allow it to display the default format the data appears correctly. Since the default shows both date and time, I want to use a custom format to display only the Date. If I enter ANY formatting in the Format field, I get garbage, The dates all display starting in 1899.

Is there a trick to getting formatted dates on a chart - or is this a bug?

Bob M

 I didn't use the Format field because I was getting mixed results, so I just use something like this in the DataX field:

  FORMAT([Date1], "MM/dd/yy")

HTH