# Format Date always Returns 1/20/1970

**URL:** <https://community.make.com/t/format-date-always-returns-1-20-1970/74491>\
**Category:** Questions\
**Tags:** parse\
**Created:** [March 9, 2025, 5:08pm UTC](https://community.make.com/t/format-date-always-returns-1-20-1970/74491 "2025-03-09T17:08:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![clarezoe](https://avatars.discourse-cdn.com/v4/letter/c/ecae2f/32.png) [@clarezoe](https://community.make.com/u/clarezoe)\
**Post date:** [March 9, 2025, 5:08pm UTC](https://community.make.com/t/format-date-always-returns-1-20-1970/74491/1 "2025-03-09T17:08:27Z")

</div>

I’m getting a Unix formated timestamp, and I’m using parseData to convert to regular date format

```auto
{{parseDate(1712299628; "x")}}

```

But no matter what number I try, it always returns 1/20/1970, sometimes 1/21/1970

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/e/ce0e43517e0675975ec1d4d6169bc01068642c72.png)  
 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/7/2743442766948dd47522e7e9c98673992afb5d8c.png)

I don’t know what went wrong. Please help!  
Thanks in advance!

---

<div class="post-metadata">

**Author:** ![Emmie\_Aderemi](https://avatars.discourse-cdn.com/v4/letter/e/9de0a6/32.png) [@Emmie\_Aderemi](https://community.make.com/u/Emmie_Aderemi)\
**Post date:** [March 9, 2025, 10:21pm UTC](https://community.make.com/t/format-date-always-returns-1-20-1970/74491/2 "2025-03-09T22:21:48Z")

</div>

Hey @clarezoe what you need is ‘‘formatdate’’ formula

---

<div class="post-metadata">

**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\
**Post date:** [March 10, 2025, 3:58am UTC](https://community.make.com/t/format-date-always-returns-1-20-1970/74491/3 "2025-03-10T03:58:07Z")

</div>

Welcome to the Make community!

According to the [Tokens](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) you can use to format a date variable, you can use `X` (capitalised).

e.g.:

```plaintext
{{ formatDate(now; "X") }}

```

**Proof:**

 ![Screenshot_2025-03-10_110319](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/6/363446bc89427e2230f5b85ad5eafbc689be8a3b.png)

For more information, see Date Format links below @Emmie_Aderemi

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

### Getting Started

- [Help Centre](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – Make “Manual”
- [Make Academy](https://academy.make.com) – Basics 101: Learn Make and get certified

### Help Centre Basics

- [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map?
- [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array
- [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output)
- **Date Format** : [tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting)
- [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file
- [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks

### Articles & Videos

- [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube
- [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist
- [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make
- [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want
- [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.

---

<div class="post-metadata">

**Author:** ![clarezoe](https://avatars.discourse-cdn.com/v4/letter/c/ecae2f/32.png) [@clarezoe](https://community.make.com/u/clarezoe)\
**Post date:** [March 26, 2025, 1:13pm UTC](https://community.make.com/t/format-date-always-returns-1-20-1970/74491/4 "2025-03-26T13:13:33Z")

</div>

Thank you! Change the x to capitalised solved it.

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [April 9, 2025, 12:16pm UTC](https://community.make.com/t/format-date-always-returns-1-20-1970/74491/5 "2025-04-09T12:16:54Z")

</div>