# $dateToString

*noun*

say it: **“DOL-er DAYT too STRING”** **/ˈdɑlər ˈdeɪt tə ˈstrɪŋ/**

A MongoDB aggregation expression that turns a date into text in a chosen format, such as its year and month.

## What does **$dateToString** do in an aggregation pipeline?

**$dateToString** turns a date into text in the format you give, such as `"%Y-%m"` for `2026-03`, which makes a good key for grouping by month. A `timezone` such as `"America/Denver"` reads the date on that clock instead of UTC.

```javascript
db.orders.aggregate([
  { $group: {
      _id: { $dateToString: { format: "%Y-%m", date: "$placedAt", timezone: "America/Denver" } },
      orders: { $sum: 1 } } }
]);
// [ { _id: '2026-03', orders: 41 }, { _id: '2026-04', orders: 57 } ]
```

## In a sentence

- “Grouping on **$dateToString** with "%Y-%m" gave one row of sales per month.”
- “Adding a timezone to **$dateToString** put the late-evening orders in the right month.”

Level: Journeyman · [More MongoDB terms at this level](https://www.ask-codey.com/glossary?category=mongodb&level=3)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/datetostring
