> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Date Manipulation Field

**TABLE OF CONTENTS**

* [1. What is Date Manipulation Field](#1.-What-is-Date-Manipulation-Field)
* [2. Date Manipulation Field Options and how to use them.](#2.-Date-Manipulation-Field-Options-and-how-to-use-them.)

* [2.1 Name](#2.1-Name%C2%A0)
* [2.2 The field for date manipulation](#2.2-The-field-for-date-manipulation%C2%A0%E2%80%8B)
* [2.3 Output field format](#2.3-Output-field-format)
* [2.4 Time Zone](#2.4-Time-Zone%C2%A0%C2%A0)

---
### 1. What is Date Manipulation Field

This field can parse a string and transform it to a DateTime object, also it can change the time zone so the DateTime can be transformed.

This field is mostly used to change or manipulate the date of the field that is being used.

### 2. Date Manipulation Field Options and how to use them.

![](https://storage.crisp.chat/users/helpdesk/website/-/8/c/2/2/8c2211a702cee800/44b58db8-2585-4c7d-a4ef-fafd7b_1rpdho7.png)

#### 2.1 Name

The name of the Date manipulation custom field that you would like to see in the Mapping section.

![](https://storage.crisp.chat/users/helpdesk/website/-/6/f/d/f/6fdfcc8c19f22800/367da681-6e5f-4d8b-94e1-057060_1evzm0j.png)

#### 2.2 The field for date manipulation

The Field that you are taking the data from.

![](https://storage.crisp.chat/users/helpdesk/website/-/1/4/3/7/1437d076c2e6fd00/b6587796-b1cf-497c-b19a-c498b9_1lah5v5.png)

#### 2.3 Output field format

The Field type that the Field for date manipulation will be converted to.

![](https://storage.crisp.chat/users/helpdesk/website/-/b/e/4/6/be465681ba22800/752908ee-67e6-4457-8005-71491f_151d8nb.png)

You are presented with the following Output options:

* Date

* Text

* Number (timestamp)

![](https://storage.crisp.chat/users/helpdesk/website/-/6/d/b/9/6db95754c21ddc0/6fa0be92-84b2-4b96-8c4d-c7086b_15xvs5r.png)

#### 2.4 Time Zone

The time zone format you wish to convert the date to

![](https://storage.crisp.chat/users/helpdesk/website/-/3/7/9/c/379c391530c7ee00/c67c2678-8009-4750-8f05-a563b5_wsnoqd.png)

**Date Format** - Defines the format that the date will be converted into.

e.g.  
YYYY-MM-DD hh:mm

DD-MM-YYYY hh:mm:ss

![](https://storage.crisp.chat/users/helpdesk/website/-/9/7/b/a/97baaf30af22d000/6cdb21ed-7c51-4a4b-a54d-41790a_105bzcu.png)

With that, we will be ending our Date Manipulation Field article.

---

We hope that this covers everything. If you have any further questions or need additional clarification please reach out to us via [[email protected]](/cdn-cgi/l/email-protection#24575154544b565064575d4a4757544d4041560a474b49) or our Chat Widget!