# How to convert text data type to date data type? **URL:** \ **Category:** Questions\ **Tags:** google-sheets, webhooks, connections\ **Created:** [January 30, 2024, 6:02am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850 "2024-01-30T06:02:55Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 30, 2024, 6:02am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/1 "2024-01-30T06:02:55Z")
Hello everyone, i created scenario where webhook get data ( only date time) , now google search rows should have to see if there any similar date time in google sheets and then google sheets update rows should have to change status of that date time. Now the problem I am facing with is the webhooks get response no matter what getting not date data type even if it’s only (YYYY-MM-DD HH:MM) - this kind of message, so that is why google sheets search rows couldnt find any relatable date time form google sheets, so that is why google sheets update rows dont know where that row number. So i need to convert my text data type into date data type. below you can see my scenario , please if anyone knows how to handle this problem please help, i would be grateful . ![Снимок экрана 2024-01-30 в 11.00.42](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/7/17e9d58b3a7c11cc4bffd10555f40934edd90b6a.png) ![Снимок экрана 2024-01-30 в 11.01.13](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/6/6/6687afb5465cf09e83109b19a6566c8842947af7.jpeg) ![Снимок экрана 2024-01-30 в 11.01.42](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/f/5f9e77389b68c2024d0f16d994420a87ec37232f.jpeg) ---
**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:** [January 30, 2024, 6:24am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/2 "2024-01-30T06:24:48Z")
Welcome to the Make community! Looks like your variable named `date` is not actually of date type yet, but only a string. Follow the [Tokens](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) to parse a date string – I’m not sure what your date looks like. e.g.: `parseDate({{1.date}}; "format_goes_here")` ## Links 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 — ### General - [Help Center](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) - [Make Academy](https://academy.make.com) – learn Make and get your certificate **← CHECK THIS OUT** - [Make Blog](https://www.make.com/en/blog) – get the latest updates - [Features & Pricing](https://www.make.com/en/pricing) ### Help Center 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) - [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) **← CHECK THIS OUT** - [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 ---
**Author:** ![sachinkadam5](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sachinkadam5/32/25887_2.png) [@sachinkadam5](https://community.make.com/u/sachinkadam5)\ **Post date:** [January 30, 2024, 9:30am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/3 "2024-01-30T09:30:20Z")
Hey! @Ali2 In your case, you have used a webhook to fetch data that includes dates in the output. If possible, could you please explain how the dates are present in the webhook data? The solution I provided below is just an example, and it specifically fetches dates from a Google Sheets document. So as you mentioned above your problem i think to get date data type you have to use these steps: 1.Set date into your google sheets in this correct date time format. ![Date](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/7/5/751f2d7847c1c8111c66743c96845c7d57e4dd41.png) 1. As you can see the date time coming from our sheets like this. ![Date1](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5dcc81efd81e05cf93c41f4a11474e1370b6faa9.png) 3.Use ‘format date’ to format your date coming from previous google sheet module like this - ![Date 2](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/8/086e45f90a128c4d192c8189016807716af2d868.png) 1. After using format date function you’ll get correct date format shown below ![Final](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/7/87cf201467d48bc19a40b46fee4fb7b29ab21227.png) ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 30, 2024, 5:08pm UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/5 "2024-01-30T17:08:03Z")
hey brother, i found out that the problem is not in data type i guess , here you can see in photo below that the filter is working fine, but i can not understand why there is no output , even if google sheets contains that kind of information. Or am i wrong ? ![Снимок экрана 2024-01-30 в 22.03.32](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/7/27f46fb833677bfeb806d6b4e276e65127b85dca.jpeg) ![Снимок экрана 2024-01-30 в 22.03.46](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/7/17296030690d8e6d77251beaace1352ed1929a8e.png) ---
**Author:** ![sachinkadam5](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sachinkadam5/32/25887_2.png) [@sachinkadam5](https://community.make.com/u/sachinkadam5)\ **Post date:** [January 31, 2024, 6:00am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/6 "2024-01-31T06:00:42Z")
@Ali2 Can you provide me with the output bundle ? for google sheets module ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 31, 2024, 6:01am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/7 "2024-01-31T06:01:12Z")
ok , A MINUTE PLEASE. ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 31, 2024, 6:02am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/8 "2024-01-31T06:02:16Z")
![Снимок экрана 2024-01-31 в 11.01.45](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/9/99bd6f4e7283db19d2933cdee5ec3c550938d24e.jpeg) THERE IT IS ---
**Author:** ![sachinkadam5](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sachinkadam5/32/25887_2.png) [@sachinkadam5](https://community.make.com/u/sachinkadam5)\ **Post date:** [January 31, 2024, 6:13am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/9 "2024-01-31T06:13:27Z")
Also can you please share your google sheet search row module? ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 31, 2024, 6:30am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/10 "2024-01-31T06:30:57Z")
SURE AND ![Снимок экрана 2024-01-31 в 11.27.40](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/a/5a1e217b28e1d982915ad691f3eefb1dad6c735f.jpeg) ![Снимок экрана 2024-01-31 в 11.27.50](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/3/7/37e9777e1152aae6b85c7959a50e56eee24f92c9.jpeg) ![Снимок экрана 2024-01-31 в 11.28.10](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/a/0a3b0206d2863afd9ef3585a001464c870cfe1d2.jpeg) ---
**Author:** ![sachinkadam5](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sachinkadam5/32/25887_2.png) [@sachinkadam5](https://community.make.com/u/sachinkadam5)\ **Post date:** [January 31, 2024, 6:53am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/11 "2024-01-31T06:53:05Z")
@Ali2 i think the date & time coming from your webhook isn’t matching the filter condition in your sheets module that’s why you are getting “0” bundle. Also can you please share your webhook output? data ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 31, 2024, 7:13am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/12 "2024-01-31T07:13:56Z")
sure there it is ![Снимок экрана 2024-01-31 в 12.13.12](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/a/2a6aedcce4950e1aa4c91f0b9f02e9758eeda64b.jpeg) ---
**Author:** ![sachinkadam5](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sachinkadam5/32/25887_2.png) [@sachinkadam5](https://community.make.com/u/sachinkadam5)\ **Post date:** [January 31, 2024, 8:41am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/13 "2024-01-31T08:41:17Z")
@Ali2 The date & time coming from your webhook is “02/02/2024” & the date you have in your sheets in all 9 rows as i can see in the snapshot that you have uploaded is “31/01/2024” & the filters you added with “And” operator in your sheet doesn’t filter the data to next module because it is not equal else your date from webhook is same as in sheet then it will give that date & time in your sheet output bundle Simply the date & time doesn’t match so the sheet module is giving you “0” or empty bundle. ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 31, 2024, 11:54am UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/14 "2024-01-31T11:54:41Z")
NO, BROTHER IN MY GOOGLE SHEETS below i have that date 02/02/2024 , this cannot be the problem we are searching for, its 4 days left im tryna understand what the problem is 🥲 🥲 🥲 ---
**Author:** ![sachinkadam5](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/sachinkadam5/32/25887_2.png) [@sachinkadam5](https://community.make.com/u/sachinkadam5)\ **Post date:** [January 31, 2024, 2:30pm UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/15 "2024-01-31T14:30:18Z")
@Ali2 Use Time operator instead of date time operator here ![Screenshot 2024-01-31 1957753](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/4/f42c13460d48c6ef0615c49fc01bd830bc0b2712.png) ![Screenshot 2024-01-31 200047](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/5/2531a5ea2e5ae62cfc78ac2ca28e28a87719a517.png) It will work. ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 31, 2024, 4:22pm UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/16 "2024-01-31T16:22:33Z")
brother, i didn’t helped, still the problem is the same 🥲 🥲 🥲 , now i have no idea what to do, and im so grateful that you have tried to help me 🖤 and i just realised that if i delete and filter where time is written it returns , but not the special one i need ---
**Author:** ![alex.newpath](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/alex.newpath/32/84_2.png) [@alex.newpath](https://community.make.com/u/alex.newpath)\ **Post date:** [January 31, 2024, 5:14pm UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/17 "2024-01-31T17:14:38Z")
Have you tried a text operator on the time filter? I mean I think the Google Sheet column looks like a text string (not a date value) so comparing them using a text operator “equals” I think may be more accurate. ---
**Author:** ![Ali2](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ali2](https://community.make.com/u/Ali2)\ **Post date:** [January 31, 2024, 5:24pm UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/18 "2024-01-31T17:24:09Z")
Yep, I JUST checked if it’s gonna help, but unfortunately nothing changed 🥲 ---
**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 30, 2024, 4:34pm UTC](https://community.make.com/t/how-to-convert-text-data-type-to-date-data-type/25850/19 "2024-04-30T16:34:04Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.