# Format Dates

The way the [ASP.NET AJAX Chart](https://www.telerik.com/products/aspnet-ajax/html-chart.aspx) dates are shown on the axis labels, series labels and series tooltips are controlled via the **DataFormatString** property that must be set in the corresponding chart element as follows:

* **Series Labels** and **Series Tooltips** - {0} and/or {1} placeholders are used to denote the corresponding SeriesItem's **X** and/or **Y** value in the **DateFormatString** followed by ":" and the desired date specifier(e.g., `DataFormatString="{1} units are ordered on {0:d}"`).

* **Axis Labels** - Only the desired date specifier must be set in the **DateFormatString** property,as placeholders are not applicable (e.g., **DataFormatString="y"**).

> note Date formats can be used inside the **Client Templates** . You can find more information	in the [Formatting Numbers](https://www.telerik.com/products/aspnet-ajax/documentation/controls/htmlchart/appearance-and-styling/format-numbers) article, in the section, *Formatting Labels and Tooltips by Using their Client Templates*.

**Table 1** lists standard date format specifiers with descriptions. **Figure 1** shows formatting the d, m|M and D pattern while **Example 1** shows the markup to create the figure.

> caption Table 1: List of standard date format specifiers with descriptions.

| **Format Specifier** | **Description**                        | **Pattern Equivalent (for en-US Culture)**                                                                                             |
| -------------------- | -------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------- |
| **d**                | short date pattern                     | **M/d/yyyy** (e.g., the date 11th of November 2000 will be formatted as "11/6/2000")                                                   |
| **D**                | long date pattern                      | **dddd, MMMM dd, yyyy** (e.g., the date 11th of November 2000 will be formatted as "Monday, November 06, 2000")                        |
| **F**                | full date/time pattern                 | **dddd, MMMM dd, yyyy h:mm:ss tt** (e.g., the date 11th of November 2000 will be formatted as "Monday, November 06, 2000 12:00:00 AM") |
| **g**                | general date/time pattern (short time) | **M/d/yyyy h:mm tt** (e.g., the date 11th of November 2000 will be formatted as "11/6/2000 12:00 AM")                                  |
| **G**                | general date/time pattern (long time)  | **M/d/yyyy h:mm:ss tt** (e.g., the date 11th of November 2000 will be formatted as "11/6/2000 12:00:00 AM")                            |
| **m** or **M**       | month/day pattern                      | **MMMM dd** (e.g., the date 11th of November 2000 will be formatted as "November 06")                                                  |
| **u**                | universal sortable date/time pattern   | **yyyy'-'MM'-'dd HH':'mm':'ss'Z'** (e.g., the date 11th of November 2000 will be formatted as "2000-11-06 00:00:00Z")                  |
| **y** or **Y**       | month/year pattern                     | **MMMM, yyyy** (e.g., the date 11th of November 2000 will be formatted as "November, 2000")                                            |

**Table 2** lists custom date format specifiers with descriptions. **Figure 2** shows formatting the "MMM-yyyy", "ddd, MMM, yyyy" and "MMM yyyy" pattern while **Example 2** shows the markup to create the figure.

> caption Table 2: List of custom date format specifiers with descriptions.

| **Format Specifier** | **Description**                                          |
| -------------------- | -------------------------------------------------------- |
| **d**                | The day of the month from 1 to 31.                       |
| **dd**               | The zero-padded day of the month from 01 to 31.          |
| **ddd**              | The abbreviated name of the day of the week.             |
| **dddd**             | The full name of the day of the week.                    |
| **M**                | The month from 1 to 12.                                  |
| **MM**               | The zero-padded month from 01 to 12.                     |
| **MMM**              | The abbreviated name of the month.                       |
| **MMMM**             | The full name of the month.                              |
| **yy**               | The year, from 00 to 99.                                 |
| **yyyy**             | The year as a four-digit number.                         |
| **h**                | The hour, using 12-hour clock from 1 to 12.              |
| **hh**               | The zero-padded hour, using 12-hour clock from 01 to 12. |
| **H**                | The hour, using 24-hour clock from 0 to 23.              |
| **HH**               | The zero-padded hour, using 24-hour clock from 00 to 23. |
| **m**                | The minute from 0 to 59.                                 |
| **mm**               | The zero-padded minute from 00 to 59.                    |
| **s**                | The second from 0 to 59.                                 |
| **ss**               | The zero-padded second from 00 to 59.                    |
| **tt**               | The AM/PM designator.                                    |

> caption Figure 1: Formatting axis labels, series labels and series tooltip with standard format via the DateFormatString property.

![htmlchart-dateaxis-overview](https://www.telerik.com/products/aspnet-ajax/documentation/assets/9effbe486aa4f1ac442ae77f7c4ba42c/htmlchart-dateaxis-overview.png)

> caption Example 1 shows the simple markup used to format the series labels, axis labels and series tooltip with standard format in **Figure 1**.

```ASP.NET
<telerik:RadHtmlChart runat="server" ID="RadHtmlChart1" Width="640px" Height="480px">
	<PlotArea>
		<Series>
			<telerik:ScatterLineSeries DataFieldY="SellQuantity" DataFieldX="SellDate">
				<LabelsAppearance DataFormatString="{1} cars sold on {0:m}">
				</LabelsAppearance>
				<TooltipsAppearance Color="White" DataFormatString="{1} cars sold on<br/>{0:D}" />
			</telerik:ScatterLineSeries>
		</Series>
		<XAxis BaseUnit="days">
			<TitleAppearance Text="Sell Date">
			</TitleAppearance>
			<LabelsAppearance DataFormatString="d">
			</LabelsAppearance>
			<MajorGridLines Color="#EFEFEF" Width="1"></MajorGridLines>
			<MinorGridLines Color="#F7F7F7" Width="1"></MinorGridLines>
		</XAxis>
		<YAxis>
			<TitleAppearance Text="Quantity">
			</TitleAppearance>
			<MajorGridLines Color="#EFEFEF" Width="1"></MajorGridLines>
			<MinorGridLines Color="#F7F7F7" Width="1"></MinorGridLines>
		</YAxis>
	</PlotArea>
	<ChartTitle Text="Sold Cars per Date">
	</ChartTitle>
</telerik:RadHtmlChart>
```

```C#
protected void Page_Load(object sender, EventArgs e)
{
	RadHtmlChart1.DataSource = GetData();
	RadHtmlChart1.DataBind();
}

protected DataTable GetData()
{
	DataTable dt = new DataTable();

	dt.Columns.Add("ID", typeof(int));
	dt.Columns.Add("SellQuantity", typeof(int));
	dt.Columns.Add("SellDate", typeof(DateTime));

	dt.Rows.Add(1, 2, new DateTime(2011, 06, 12));
	dt.Rows.Add(2, 5, new DateTime(2011, 12, 12));
	dt.Rows.Add(3, 6, new DateTime(2012, 06, 17));
	dt.Rows.Add(4, 4, new DateTime(2012, 09, 18));
	dt.Rows.Add(5, 7, new DateTime(2013, 03, 18));

	return dt;
}
```

```VB
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
	RadHtmlChart1.DataSource = GetData()
	RadHtmlChart1.DataBind()
End Sub

Protected Function GetData() As DataTable
	Dim dt As New DataTable()

	dt.Columns.Add("ID", GetType(Integer))
	dt.Columns.Add("SellQuantity", GetType(Integer))
	dt.Columns.Add("SellDate", GetType(DateTime))

	dt.Rows.Add(1, 2, New DateTime(2011, 6, 12))
	dt.Rows.Add(2, 5, New DateTime(2011, 12, 12))
	dt.Rows.Add(3, 6, New DateTime(2012, 6, 17))
	dt.Rows.Add(4, 4, New DateTime(2012, 9, 18))
	dt.Rows.Add(5, 7, New DateTime(2013, 3, 18))

	Return dt
End Function
```

> caption Figure 2: Formatting axis labels, series labels and series tooltip with custom pattern via the DateFormatString property.

![htmlchart-formattingdates-customdateformats](https://www.telerik.com/products/aspnet-ajax/documentation/assets/3b3f829f221f1bbfe4611f9924d94a56/htmlchart-formattingdates-customdateformats.png)

> caption Example 2 shows the simple markup used to format the series labels, axis labels and series tooltip with custom pattern in **Figure 2**.

```ASP.NET
<telerik:RadHtmlChart runat="server" ID="RadHtmlChart1" Width="640px" Height="480px">
	<PlotArea>
		<Series>
			<telerik:ScatterLineSeries DataFieldY="SellQuantity" DataFieldX="SellDate">
				<LabelsAppearance DataFormatString="{1} cars sold on {0:MMM-yyyy}">
				</LabelsAppearance>
				<TooltipsAppearance Color="White" DataFormatString="{1} cars sold on<br/>{0:ddd, MMM, yyyy}" />
			</telerik:ScatterLineSeries>
		</Series>
		<XAxis BaseUnit="days">
			<TitleAppearance Text="Sell Date">
			</TitleAppearance>
			<LabelsAppearance DataFormatString="MMM yyyy">
			</LabelsAppearance>
			<MajorGridLines Color="#EFEFEF" Width="1"></MajorGridLines>
			<MinorGridLines Color="#F7F7F7" Width="1"></MinorGridLines>
		</XAxis>
		<YAxis>
			<TitleAppearance Text="Quantity">
			</TitleAppearance>
			<MajorGridLines Color="#EFEFEF" Width="1"></MajorGridLines>
			<MinorGridLines Color="#F7F7F7" Width="1"></MinorGridLines>
		</YAxis>
	</PlotArea>
	<ChartTitle Text="Sold Cars per Date">
	</ChartTitle>
</telerik:RadHtmlChart>
```

```C#
protected void Page_Load(object sender, EventArgs e)
{
	RadHtmlChart1.DataSource = GetData();
	RadHtmlChart1.DataBind();
}

protected DataTable GetData()
{
	DataTable dt = new DataTable();

	dt.Columns.Add("ID", typeof(int));
	dt.Columns.Add("SellQuantity", typeof(int));
	dt.Columns.Add("SellDate", typeof(DateTime));

	dt.Rows.Add(1, 2, new DateTime(2011, 06, 12));
	dt.Rows.Add(2, 5, new DateTime(2011, 12, 12));
	dt.Rows.Add(3, 6, new DateTime(2012, 06, 17));
	dt.Rows.Add(4, 4, new DateTime(2012, 09, 18));
	dt.Rows.Add(5, 7, new DateTime(2013, 03, 18));

	return dt;
}
```

```VB
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load
	RadHtmlChart1.DataSource = GetData()
	RadHtmlChart1.DataBind()
End Sub

Protected Function GetData() As DataTable
	Dim dt As New DataTable()

	dt.Columns.Add("ID", GetType(Integer))
	dt.Columns.Add("SellQuantity", GetType(Integer))
	dt.Columns.Add("SellDate", GetType(DateTime))

	dt.Rows.Add(1, 2, New DateTime(2011, 6, 12))
	dt.Rows.Add(2, 5, New DateTime(2011, 12, 12))
	dt.Rows.Add(3, 6, New DateTime(2012, 6, 17))
	dt.Rows.Add(4, 4, New DateTime(2012, 9, 18))
	dt.Rows.Add(5, 7, New DateTime(2013, 3, 18))

	Return dt
End Function
```

> note The above dates are formatted in the default "en-US" culture. More information on how to localize text elements is available in the [Localization](https://www.telerik.com/products/aspnet-ajax/documentation/controls/htmlchart/accessibility-and-internationalization/localization) article.

## See Also

* [Date Axis](https://www.telerik.com/products/aspnet-ajax/documentation/controls/htmlchart/functionality/axes/date-axis)

* [Format Numbers](https://www.telerik.com/products/aspnet-ajax/documentation/controls/htmlchart/appearance-and-styling/format-numbers)

* [Localization](https://www.telerik.com/products/aspnet-ajax/documentation/controls/htmlchart/accessibility-and-internationalization/localization)
