# \#date-time-functions **URL:** https://community.make.com/tag/date-time-functions/145.md [Latest](https://community.make.com/latest.md) · [Categories](https://community.make.com/categories.md) · [Tags](https://community.make.com/tags.md) --- ## [Notion Date field accepts "now" but rejects all date manipulation functions - Invalid date in parameter 'start'](https://community.make.com/t/notion-date-field-accepts-now-but-rejects-all-date-manipulation-functions-invalid-date-in-parameter-start/109153)
**Author:** [@jpkkite](https://community.make.com/u/jpkkite)\ **Replies:** 2\ **Last updated:** [August 3, 2026, 7:17am UTC](https://community.make.com/t/notion-date-field-accepts-now-but-rejects-all-date-manipulation-functions-invalid-date-in-parameter-start/109153 "2026-08-03T07:17:16Z")
Hi everyone, I’ve been building a scenario to automatically generate Notion database entries for specific dates each month, and I’ve hit a very specific issue with Notion’s date field that I can’t resolve. The finding: … --- ## [Facing problem in applying date/time function](https://community.make.com/t/facing-problem-in-applying-date-time-function/112726)
**Author:** [@Hadeed\_Shafqat\_Salik](https://community.make.com/u/Hadeed_Shafqat_Salik)\ **Replies:** 8\ **Last updated:** [July 30, 2026, 1:06am UTC](https://community.make.com/t/facing-problem-in-applying-date-time-function/112726 "2026-07-30T01:06:16Z")
:bullseye: What is your goal? Add the accurate date and time for Paris and New York in the Google sheet with no extra text. :thinking: What is the problem? I’m making a scenario in Make where I’m practising date/time fu… --- ## [Facing problem in applying function date/time](https://community.make.com/t/facing-problem-in-applying-function-date-time/112725)
**Author:** [@Hadeed\_Shafqat\_Salik](https://community.make.com/u/Hadeed_Shafqat_Salik)\ **Replies:** 0\ **Last updated:** [July 29, 2026, 3:59pm UTC](https://community.make.com/t/facing-problem-in-applying-function-date-time/112725 "2026-07-29T15:59:35Z")
:bullseye: What is your goal? Add the accurate date and time for Paris and New York in the Google sheet with no extra text. :thinking: What is the problem & what have you tried? I’m making a scenario in Make where I’m p… --- ## [I see error when using datetime operator in google sheet](https://community.make.com/t/i-see-error-when-using-datetime-operator-in-google-sheet/112690)
**Author:** [@Saswat\_Sandipani\_Pat](https://community.make.com/u/Saswat_Sandipani_Pat)\ **Replies:** 5\ **Last updated:** [July 29, 2026, 8:25am UTC](https://community.make.com/t/i-see-error-when-using-datetime-operator-in-google-sheet/112690 "2026-07-29T08:25:05Z")
:bullseye: What is your goal? I want to automate a daily check on my Google Sheet (a Time and Action / production calendar). Every day, Make should scan the sheet, find all rows where the “stitching expected date” match… --- ## [How to extract last sheet name from a google spreadsheet](https://community.make.com/t/how-to-extract-last-sheet-name-from-a-google-spreadsheet/111703)
**Author:** [@Marcelo\_Polizzotto](https://community.make.com/u/Marcelo_Polizzotto)\ **Replies:** 4\ **Last updated:** [July 7, 2026, 1:36am UTC](https://community.make.com/t/how-to-extract-last-sheet-name-from-a-google-spreadsheet/111703 "2026-07-07T01:36:23Z")
:bullseye: What is your goal? If my sheet last name of my google spreadsheet is not created (which should be the current month name or month number) I should create this new sheet with google sheets standard function to … --- ## [Separating invoice dates from filenames for automation](https://community.make.com/t/separating-invoice-dates-from-filenames-for-automation/106876)
**Author:** [@Skeynor](https://community.make.com/u/Skeynor)\ **Replies:** 8\ **Last updated:** [April 6, 2026, 9:06pm UTC](https://community.make.com/t/separating-invoice-dates-from-filenames-for-automation/106876 "2026-04-06T21:06:06Z")
:bullseye: What is your goal? I have a scenario that searches for invoices I get and adds them to the google drive. They all are named “Invoice DD.MM.YYYY”. I wanted to add a module to look for the invoices with the date… --- ## [Create Google Calendar event | Daylight savings issue](https://community.make.com/t/create-google-calendar-event-daylight-savings-issue/106226)
**Author:** [@Letter\_Love](https://community.make.com/u/Letter_Love)\ **Replies:** 3\ **Last updated:** [March 24, 2026, 8:18pm UTC](https://community.make.com/t/create-google-calendar-event-daylight-savings-issue/106226 "2026-03-24T20:18:25Z")
:bullseye: What is your goal? Create a future Google Calendar event that will account for Daylight Savings time. :thinking: What is the problem & what have you tried? When the event is created before DST, the time is in… --- ## [Date/Time calculation Excel/Tally form](https://community.make.com/t/date-time-calculation-excel-tally-form/104486)
**Author:** [@Joachim\_M\_Vis](https://community.make.com/u/Joachim_M_Vis)\ **Replies:** 2\ **Last updated:** [February 28, 2026, 6:55pm UTC](https://community.make.com/t/date-time-calculation-excel-tally-form/104486 "2026-02-28T18:55:26Z")
:bullseye: What is your goal? Need to calculate the time difference between the scheduled date/time (DD.MM.YYYY HH:mm) in an Excel file and the time from a Tally form (HH:mm) for the Estimated Time of Arrival (ETA). … --- ## [Calculate Date Difference Between Two Dates in Days](https://community.make.com/t/calculate-date-difference-between-two-dates-in-days/101090)
**Author:** [@Angelo\_Sunny](https://community.make.com/u/Angelo_Sunny)\ **Replies:** 3\ **Last updated:** [January 23, 2026, 7:36am UTC](https://community.make.com/t/calculate-date-difference-between-two-dates-in-days/101090 "2026-01-23T07:36:27Z")
:bullseye: What is your goal? I want to calculate the no of days from a difference of 2 dates :thinking: What is the problem & what have you tried? i tried diff formulas to get the no.of days but everytime the variable … --- ## [Make is swapping the day and month when parsing dates](https://community.make.com/t/make-is-swapping-the-day-and-month-when-parsing-dates/97512)
**Author:** [@Ardra\_KS](https://community.make.com/u/Ardra_KS)\ **Replies:** 4\ **Last updated:** [December 10, 2025, 5:38am UTC](https://community.make.com/t/make-is-swapping-the-day-and-month-when-parsing-dates/97512 "2025-12-10T05:38:07Z")
:bullseye: What is your goal? To parse a date received from Tally (in YYYY-MM-DD format), convert it to DD/MM/YYYY, and store it correctly in a Make Datastore without any changes or misinterpretation. :thinking: What is… --- ## [Datetime filter not working](https://community.make.com/t/datetime-filter-not-working/97479)
**Author:** [@Deana\_Marshall](https://community.make.com/u/Deana_Marshall)\ **Replies:** 10\ **Last updated:** [November 28, 2025, 12:30am UTC](https://community.make.com/t/datetime-filter-not-working/97479 "2025-11-28T00:30:22Z")
:bullseye: What is your goal? I am trying to filter bundles with either date added or date modified that happened the previous day :thinking: What is the problem & what have you tried? It is passing everything through t… --- ## [Make don't capture the right time from Todoist](https://community.make.com/t/make-dont-capture-the-right-time-from-todoist/97472)
**Author:** [@Marco7](https://community.make.com/u/Marco7)\ **Replies:** 2\ **Last updated:** [November 27, 2025, 1:21pm UTC](https://community.make.com/t/make-dont-capture-the-right-time-from-todoist/97472 "2025-11-27T13:21:06Z")
:bullseye: What is your goal? The goal is to capture the tasks that with Todoist and to transfer them directly to my Notion (calendar) with Make. :thinking: What is the problem & what have you tried? the problem is that… --- ## [How to Filter HubSpot “Last CV” Updates Within the Past Hour?](https://community.make.com/t/how-to-filter-hubspot-last-cv-updates-within-the-past-hour/97359)
**Author:** [@Atsushi\_Shibata](https://community.make.com/u/Atsushi_Shibata)\ **Replies:** 6\ **Last updated:** [November 27, 2025, 9:29am UTC](https://community.make.com/t/how-to-filter-hubspot-last-cv-updates-within-the-past-hour/97359 "2025-11-27T09:29:46Z")
:bullseye: What is your goal? I want to send a Slack notification every hour when a HubSpot contact’s last CV is updated. To do this, the scenario should trigger only when the last CV timestamp is within the past hour si… --- ## [Date Filter for Google Sheets Search Issue!](https://community.make.com/t/date-filter-for-google-sheets-search-issue/95863)
**Author:** [@Matt\_Price](https://community.make.com/u/Matt_Price)\ **Replies:** 2\ **Last updated:** [November 10, 2025, 11:00am UTC](https://community.make.com/t/date-filter-for-google-sheets-search-issue/95863 "2025-11-10T11:00:05Z")
Hi All, I am having the common problem of searching google sheets rows and filtering by a date, which is returning the wrong dates. There seems to be a difference between how Google Sheets & Make format or interpret a d… --- ## [How to convert August 10, 2025 9:30 AM to Unix timestamp](https://community.make.com/t/how-to-convert-august-10-2025-9-30-am-to-unix-timestamp/89260)
**Author:** [@Sergei\_1](https://community.make.com/u/Sergei_1)\ **Replies:** 1\ **Last updated:** [November 6, 2025, 8:08am UTC](https://community.make.com/t/how-to-convert-august-10-2025-9-30-am-to-unix-timestamp/89260 "2025-11-06T08:08:19Z")
Hey everyone, could use some guidance here, I’ve tried so many ways to come to a solution but not getting anywhere at this point. I have an incoming webhook with date field: August 10, 2025 9:30 AM and I need to convert … --- ## [Send email on the next weekday at 9 am](https://community.make.com/t/send-email-on-the-next-weekday-at-9-am/94855)
**Author:** [@apps](https://community.make.com/u/apps)\ **Replies:** 2\ **Last updated:** [October 27, 2025, 6:14am UTC](https://community.make.com/t/send-email-on-the-next-weekday-at-9-am/94855 "2025-10-27T06:14:18Z")
I have a scenario that sends an email. I want to send an email on the next weekday at 9 am, so if the scenario is triggered on a Friday to a Sunday, the email should be sent on Monday at 9 am and if on Monday, on Tuesday… --- ## [UK Timezone is GMT+1 as its British Summer Time BUT](https://community.make.com/t/uk-timezone-is-gmt-1-as-its-british-summer-time-but/94830)
**Author:** [@crm\_automator](https://community.make.com/u/crm_automator)\ **Replies:** 0\ **Last updated:** [October 26, 2025, 10:00am UTC](https://community.make.com/t/uk-timezone-is-gmt-1-as-its-british-summer-time-but/94830 "2025-10-26T10:00:28Z")
When I pass a meeting datetime to our CRM it stores it one hour earlier in the database. My Organization Settings are set to “(GMT+00:00) Europe/London”. However the UK is not currently GMT+00:00. How would I implemen… --- ## [formatDate(addDays(now;1);"EEE") always returns "555" in Tools module](https://community.make.com/t/formatdate-adddays-now-1-eee-always-returns-555-in-tools-module/93676)
**Author:** [@Harel\_khafi](https://community.make.com/u/Harel_khafi)\ **Replies:** 1\ **Last updated:** [October 9, 2025, 12:55pm UTC](https://community.make.com/t/formatdate-adddays-now-1-eee-always-returns-555-in-tools-module/93676 "2025-10-09T12:55:44Z")
Hi everyone :waving\_hand: I’ve encountered a strange behavior when using the following expression inside a Tools → Set variable or Set multiple variables module: formatDate(addDays(now; 1); "EEE") Instead of returnin… --- ## [Facebook Module changes time](https://community.make.com/t/facebook-module-changes-time/93259)
**Author:** [@workflowsprout](https://community.make.com/u/workflowsprout)\ **Replies:** 1\ **Last updated:** [October 2, 2025, 3:57pm UTC](https://community.make.com/t/facebook-module-changes-time/93259 "2025-10-02T15:57:15Z")
Hi, Somehow my facebook module changes the time I set to 2 hours in advance. My profile setting and my organisation setting are on: The facebook module is also set to Amsterdam Time: However see this example, w… --- ## [Date issue when creating filled in Word Documents](https://community.make.com/t/date-issue-when-creating-filled-in-word-documents/92998)
**Author:** [@Dylan\_Brown](https://community.make.com/u/Dylan_Brown)\ **Replies:** 2\ **Last updated:** [September 29, 2025, 12:00pm UTC](https://community.make.com/t/date-issue-when-creating-filled-in-word-documents/92998 "2025-09-29T12:00:30Z")
Hi, A brief outline on what I’m trying to make, we have a site attendance software which gives us a csv file once a week with everyone’s sign in and sign out times and location. I’m trying to make an automated solution … --- ## [How do I get these dates to format properly in Make as they appear in my Google Calendar?](https://community.make.com/t/how-do-i-get-these-dates-to-format-properly-in-make-as-they-appear-in-my-google-calendar/91833)
**Author:** [@to\_scopium](https://community.make.com/u/to_scopium)\ **Replies:** 2\ **Last updated:** [September 12, 2025, 10:54pm UTC](https://community.make.com/t/how-do-i-get-these-dates-to-format-properly-in-make-as-they-appear-in-my-google-calendar/91833 "2025-09-12T22:54:52Z")
Hi guys I am trying to retrieve the busy sections on a particular date from my Google Calendar and when I run my GC module it returns the date and busy time slots as expected. As you can see it is returning 2 busy sl… --- ## [Changing date formats from text to Airtable field](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588)
**Author:** [@morgan\_moussier](https://community.make.com/u/morgan_moussier)\ **Replies:** 6\ **Last updated:** [August 15, 2025, 3:26pm UTC](https://community.make.com/t/changing-date-formats-from-text-to-airtable-field/89588 "2025-08-15T15:26:20Z")
Hello everyone, I need help !!! I’m trying to populate a date/time field in Airtable that is set to Local format (14/08/2025). The data I need to retrieve comes out of my Text Parser module in the following format: … --- ## [Dropbox Watch files modules is currently not working? is there a mayor issue reported?](https://community.make.com/t/dropbox-watch-files-modules-is-currently-not-working-is-there-a-mayor-issue-reported/88863)
**Author:** [@Rafael\_Sanchez](https://community.make.com/u/Rafael_Sanchez)\ **Replies:** 0\ **Last updated:** [August 5, 2025, 5:54pm UTC](https://community.make.com/t/dropbox-watch-files-modules-is-currently-not-working-is-there-a-mayor-issue-reported/88863 "2025-08-05T17:54:49Z")
Hello Community I wonder if Dropbox Watch files modules is currently not working? is there a mayor issue reported? I’ve been with issue of this module not pulling recently added files in subfolders event the option to W… --- ## [Date filtering after date 1, before date 2 do something](https://community.make.com/t/date-filtering-after-date-1-before-date-2-do-something/87845)
**Author:** [@MartinR](https://community.make.com/u/MartinR)\ **Replies:** 2\ **Last updated:** [July 23, 2025, 7:07am UTC](https://community.make.com/t/date-filtering-after-date-1-before-date-2-do-something/87845 "2025-07-23T07:07:20Z")
What are you trying to achieve? I need to check if a date falls within a quarter (i.e. April-June, July-Sept, Oct-Dec, Jan-March) and do something based on that. I get today’s date with the (now) function. I’ve done eve… --- ## [Posting from Google Search Row](https://community.make.com/t/posting-from-google-search-row/87682)
**Author:** [@David\_Solomon](https://community.make.com/u/David_Solomon)\ **Replies:** 0\ **Last updated:** [July 20, 2025, 9:33pm UTC](https://community.make.com/t/posting-from-google-search-row/87682 "2025-07-20T21:33:39Z")
I have a scenario starting with a google search row, then pinterest then google update row. My goal is to post from the goolgle search row which has the date and time that a pin should be be posted. I have the custom sch… --- ## [How to clear time/date](https://community.make.com/t/how-to-clear-time-date/86358)
**Author:** [@Rishad\_Ibrahimov](https://community.make.com/u/Rishad_Ibrahimov)\ **Replies:** 1\ **Last updated:** [July 9, 2025, 11:45am UTC](https://community.make.com/t/how-to-clear-time-date/86358 "2025-07-09T11:45:33Z")
I’m getting this date/time, and i want to add it to google sheet like “10:00 am 10 jul” What I mean is to make it clear EDIT: add tools + compose a sting and select time thing then do something and done --- ## [How can I convert date from E-mail module?](https://community.make.com/t/how-can-i-convert-date-from-e-mail-module/86224)
**Author:** [@Ferenc\_Fellner](https://community.make.com/u/Ferenc_Fellner)\ **Replies:** 0\ **Last updated:** [July 3, 2025, 12:43pm UTC](https://community.make.com/t/how-can-i-convert-date-from-e-mail-module/86224 "2025-07-03T12:43:27Z")
I need to convert Headers - Basic: date from the E-mail module (with G-mail account) to Make standard format using Parsedate. I tried parseDate( Headers - Basic: date; ddd, D MMM YYYY HH:mm:ss Z ), but it does not work… --- ## [Get a future date that falls on a specific day of week from a Date variable (e.g.: now)](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657)
**Author:** [@m\_m](https://community.make.com/u/m_m)\ **Replies:** 4\ **Last updated:** [June 30, 2025, 8:40am UTC](https://community.make.com/t/get-a-future-date-that-falls-on-a-specific-day-of-week-from-a-date-variable-e-g-now/84657 "2025-06-30T08:40:38Z")
I’m trying to calculate a date that always falls on the Wednesday of the third week starting from today. Important: I don’t mean “exactly 21 days from now” – I specifically want the Wednesday in the third calendar wee… --- ## [Date & Time Error](https://community.make.com/t/date-time-error/85500)
**Author:** [@Matt\_Ramoundos](https://community.make.com/u/Matt_Ramoundos)\ **Replies:** 4\ **Last updated:** [June 24, 2025, 4:20am UTC](https://community.make.com/t/date-time-error/85500 "2025-06-24T04:20:33Z")
Hi there - I’m new to all of this. After spending hours trying to figure out the correct formatting, I am trying here before I give up. The following code is successful: { “query”: { “filter”: { “location\_ids”: \[ … --- ## [Creating a 48 hour timer that notifies me once and doesnt repeat](https://community.make.com/t/creating-a-48-hour-timer-that-notifies-me-once-and-doesnt-repeat/84258)
**Author:** [@Andrew\_m](https://community.make.com/u/Andrew_m)\ **Replies:** 2\ **Last updated:** [June 6, 2025, 12:32pm UTC](https://community.make.com/t/creating-a-48-hour-timer-that-notifies-me-once-and-doesnt-repeat/84258 "2025-06-06T12:32:22Z")
so far i have tested this by itself it will go along another filter that works independently, i tried using addMinutes(now; -1) to test it out npot entirely sure why its not working what i need is a timer that goes … [Next page](https://community.make.com/tag/date-time-functions/145.md?match_all_tags=true&page=1&tags%5B%5D=date-time-functions)