# Getting the correct timestamp/username from Slack to a Google Sheet

**URL:** <https://community.make.com/t/getting-the-correct-timestamp-username-from-slack-to-a-google-sheet/80545>\
**Category:** Questions\
**Tags:** slack, google-sheets\
**Created:** [April 30, 2025, 7:28am UTC](https://community.make.com/t/getting-the-correct-timestamp-username-from-slack-to-a-google-sheet/80545 "2025-04-30T07:28:22Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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:** [May 1, 2025, 6:56am UTC](https://community.make.com/t/getting-the-correct-timestamp-username-from-slack-to-a-google-sheet/80545/3 "2025-05-01T06:56:02Z")

</div>

Welcome to the Make community!

According to the [Tokens](https://help.make.com/tokens-for-datetime-parsing) you can use to parse a numeric date variable, you can use `X`.

e.g.:

```plaintext
{{ parseDate(7.timestamp; "X") }}

```

Then, you can use the `formatDate` function with your desired format.

For more information, see Date Format links below.

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://help.make.com/create-your-first-scenario) – Make “Manual” - search for help here first
- [Make Academy](https://academy.make.com) – Basics 101: Learn Make properly to get your money’s worth

### Help Centre Basics

- [Mapping](https://help.make.com/mapping) – What is mapping? What can I map?
- [Mapping with arrays](https://help.make.com/mapping-arrays) – How to map items in an array
- [Aggregate an array for mapping complex fields](https://help.make.com/flow-control#VhcUm)
- **Date Format** : [tokens for `parseDate`](https://help.make.com/tokens-for-datetime-parsing) | [tokens for `formatDate`](https://help.make.com/tokens-for-datetime-formatting)
- [HTTP modules](https://apps.make.com/http) – Make a request, Get (download) a file
- [Webhooks](https://help.make.com/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
- [Text Parser module](https://help.make.com/text-parser) - 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

---

_[View the full topic](https://community.make.com/t/getting-the-correct-timestamp-username-from-slack-to-a-google-sheet/80545)._