> For the complete documentation index, see [llms.txt](https://help.advizorsolutions.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.advizorsolutions.com/using-advizor/author-ribbon/condition-data/date-parser-view.md).

# Date Formatter

[Watch a video about using the date formatter in our tutorial page](http://advizorsolutions.com/help/central/7.5/).

The Date Formatter can be used to generate new date/time fields for a dataset without having to manually edit the data source. New date/time fields are created in the project using one of 29 format options, based on data values from an existing field with a DateTime data type.

![](/files/-Lf5ZzJazX4hmYZA6jPQ)

The Date Formatter can be very useful for generating rollups (e.g., week, quarter, month, year) from a detailed date format. However, be aware that the result data type is (currently) a String, not a Date, so use a format that will sort properly and be aware that some charts that accept dates do not accept string (e.g., Time Table x axis). The formats that will sort properly are marked with a "check" in the "Sortable" column.

To access the **Date Formatter**, select Date Formatter button ![](/files/-Lf5ZzJf-ufr8ilwG9x4) from the Author Ribbon or click the Date Formatter button ![](/files/-Lf5ZzJh379J9clf3L0A) in the [Project Workshop](/using-advizor/author-ribbon/condition-data/project-workshop-view.md) toolbar. Select a table from the **Table** pulldown list.Select a **DateTime** field from the pulldown list. **Only fields with the DateTime data type will appear in this list.**

In the Date/Time Field Options grid, select the checkbox for the applicable format option that will be used to generate the new date/time field. Once you select a format, the New Field Name column displays a default field name. You can edit this name as desired by clicking on the New Field Name cell and editing the existing name or typing in a new name.

NOTE 1: You can select multiple date/time field options.

NOTE 2: If the data values in the source DateTime field do not contain the necessary information, the generated field will contain empty data values (zeros). For example, if you selected the Hour:Minute format option and the source DateTime field does not contain time values, the new Hour:Minute field will be displayed 00:00 data values.

Click Apply to add new fields to the selected table in the data pool.

**See also:**

* [Project Workshop](/using-advizor/author-ribbon/condition-data/project-workshop-view.md)
* [Expression Builder](https://help.advizorsolutions.com/v/v7.5/using-advizor/author-ribbon/condition-data/use-the-expression-builder)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://help.advizorsolutions.com/using-advizor/author-ribbon/condition-data/date-parser-view.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.