---
title: "Date Transform Overview"
slug: "dmath-overview"
updated: 2021-10-20T12:50:39Z
published: 2021-10-20T12:50:39Z
canonical: "docs.datajet.app/dmath-overview"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# Date Transform Overview

## Date Transform Functions

## Functions that operate on Date and DateTime fields and that manipulate years, months and days

## Purpose

Use Date Transform functions to:

- Manipulate days, weeks and months in a date field
- Calculate elapsed time in days, weeks and months
- Create string values from dates
- Create dates from integer values
- Segment data into days, weeks and months, quarters and years

## Return Value

| Property | Value | Notes |
| --- | --- | --- |
| **FieldType** | String / Integer / Date | Date transforms return a variety of field types, depending on the individual function. |
| **FieldSize** | Low / Med / High | Low - up to 250 unique values Med - Up to 65,630 unique values High - up to 1,000,000 unique values |
| **DataType** | Discrete | Date fields are always discrete, and so are the fields created from them |
| **DataSize** | Short / Integer | Short - Up to 65,630 unique values Integer - up to 1,000,000 unique values |

```shell
Example Return Value: 
-n*.nnnnnn....n*.nnnnnn

e.g. -509.000000......90876.123456
```

### Parameters

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/DATETRANSFORM_OVERVIEW_Parameters.PNG)

| Parameter | JSON | Description |
| --- | --- | --- |
| **Table** | “targetTable”: “MyTableName” | The target table on which the new field will be created |
| **Filter** | “dataset”: {DataSet_JSON} | Optional. If a filter is applied, records not in the filter recordset will be returned as null. |
| **Date** **Function** | “p1”: “” | Select the Date Transform function from the drop-down list. Specifies the function to use. |
| **A - C** | “p2-4”: “NumericFieldName” “p2-4”: “#YYYY-MM-DD” “p2-4”: “#YYYY-MM-DD HH:MM:SS” “p2-4”: “#N*” | Fields/Inputs to use for A-C. The date from which to extract the year and month *Supports:* - **DataType:** Discrete / Continuous - **Field Type:** Date, DateTime, Integer - **Fixed Value:** #YYYY-MM-DD, e.g. #2021-04-05 - **Fixed Value:** #YYYY-MM-DD HH:MM:SS, e.g. #2021-04-05 11:01:08 - **Fixed Value:** #NN, e.g. #10 |
| Name | "name" : "FieldName" | Required. The name of the field to create. |

## JSON Sample

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/DATETRANSFORM_OVERVIEW_JSON.PNG)

## Usage Notes

See Also:

- [Field and Table Names](/v1/docs/generaltemplate)
- {TODO: Field and Data Types}
- {TODO: Engineering How To}

##