Calculate Number of Days Between Two Dates

Calculate the number of days between two given date fields and populate this number into a field on the form.

February 10, 2015: Fixed issue where non-US date formats were not working as expected. Added link on demo to alternate version.

September 17, 2014: Fixed issue with newer versions of jQuery UI Datepicker where "change" event was not fired when a date was selected and day count was not calculated.

March 15, 2013: Updated to fix issue when conditional logic was used on the form.

March 3, 2013: Updated to fix issue where "include_end_date" option was not working and added better support for different date formats.

March 2, 2013: Updated to support applying to multiple sets of date fields on the same form. Also updated to fix issue where functionality did not run when form was returned due to validation error.

Stop! There's a better way.

This snippet is available as a plugin with Gravity Perks, a suite of over 47 premium Gravity Forms plugins!

View Plugin Buy Gravity Perks

Have you ever needed to calculate the number of days between two given date fields? Here’s a scenario for consideration.

Let’s say you have a Gravity Form set up to register users for a multi-day event. The user is able to select a start date and end date that they will be attending the event. For each day of attendance they must pay an attendance fee of $10. How can we calculate the total price they should pay for registration?

This snippet will allow to calculate the number of days between two date fields and then populate the calculated number of days into another field. This is beneficial because with this calculated number of days now available as a field value, we can use Gravity Forms’ Calculation Product to correctly calculate the registration fee based on the selected dates.

How do I install this snippet?

Easy peasy. Just copy and paste the code above into your theme's functions.php file.

How do I use this functionality?

To use this snippet’s functionality just go directly below the snippet and instantiate the GWDayCount() class. Instantiate is a big word but all it means is that you’ll be creating a new “instance” of the GWDayCount() class with a set of parameters (aka options) for that specific instance.

Standard Usage

new GWDayCount( array(
	'form_id'        => 9,
	'start_field_id' => 1,
	'end_field_id'   => 2,
	'count_field_id' => 3
	) );
Count “Nights” Only
End date is not included in the day count so you are essentially counting the number of “nights” between the two dates.

new GWDayCount( array(
	'form_id'          => 9,
	'start_field_id'   => 1,
	'end_field_id'     => 2,
	'count_field_id'   => 3,
	'include_end_date' => false
	) );

Once you instantiated the class you are finished! If you would like to have this functionality on multiple forms then just create a new instance of the class and fill in the parameters for the new form. That’s it!

Parameter Details

  • form_id: The form ID of the form you would like to apply this functionality to.
  • start_field_id: The ID of the date field that will contain the start date. This field must be a date field and the parameter only holds a single field.
  • end_field_id: This parameter holds the ID of the date field that will contain the forms end date. This field, like the start_field_id field, must be a date field and only holds a single field ID.
  • count_field_id: This parameter holds the ID of the field that will be populated with the calculated number of days between the start date and end date.
  • include_end_date: Defaults to true. Set to this false if you would like to count only “nights” where the start date would be the check-in date and the end date would be the check-out date.

Points of Note

  • This is currently only setup to work with “Date Picker” date fields. Let me know if you need this with other types of date fields in the comments.

Comments

  1. Amit deshmukh
    Amit deshmukh July 14, 2023 at 2:18 am

    Hi got error while adding code in function.php.

    Your PHP code changes were rolled back due to an error on line 191 of file wp-content/themes/astra/functions.php. Please fix and try saving again.

    syntax error, unexpected token “<“, expecting end of file

    Reply
  2. Ivo Kittel
    Ivo Kittel June 28, 2023 at 11:43 am

    Hi, Great snippet and works great. Am just having an issue whereby the calculated days are not showing correctly in the notification emails sent. On screen all is 100% but when I receive the notification, the days are always set to 1. Any ideas?

    Reply
    1. Samuel Bassah
      Samuel Bassah Staff June 28, 2023 at 12:37 pm

      Hi Ivo,

      I’m not sure why that is happening. We’ll need to dig into this further to know what’s happening. I’ll contact you via email to request additional information.

      Best,

    2. Ivo
      Ivo July 5, 2023 at 9:11 am

      Hi Samuel, You manage to look into the issue or perhaps you can send me an email so I can you more information?

    3. Samuel Bassah
      Samuel Bassah Staff July 5, 2023 at 12:12 pm

      Hi Ivo,

      I sent you an email on 28th June 2023, requesting you to send us an export of the form. I guess you didn’t receive it. Since you have an active Gravity Perks license, can you submit a support ticket with us via our support form and attach an export of the form.

      Best,

  3. Mat
    Mat September 25, 2022 at 6:35 am

    Hi David, a great snippet of code. Thank you.

    I would like to know if it is possible, to calculate only the first 7 days of the reservation and not to calculate the rest days as an additional cost. Because we want to charge only for the first 7 days and the rest to be free, Thank you.

    Reply
    1. David Smith
      David Smith Staff September 26, 2022 at 11:56 am

      Hey Mat, glad you’re enjoying the snippet! Unfortunately, it doesn’t support setting a “max” value.

      This would be possible using Date Time Calculator to handle the date calculation and Advanced Calculations min method which would return the lowest number (e.g. 7 or the actual number of days calculated).

  4. Alexis
    Alexis May 22, 2022 at 4:04 pm

    First, sorry for my english.

    I’m trying this code, but it doesn’t work. I’ve added the code to functions.php (I have also tried with the snippets plugin) and filled in the form data in the function, but not show anything on view.

    Fecha inicio (date field) ID: 1 Fecha fin (date field) ID: 2 Diferencia de dias (number field) ID: 3 Form: ID 5

    Configuration

    new GWDayCount( array( ‘form_id’ => 5, ‘start_field_id’ => 1, ‘end_field_id’ => 2, ‘count_field_id’ => 3 ) );

    But not show anymore:

    http://clinicacamposfisioterapia.com/view/diferencia-fechas/

    Can you help me, please?

    Reply
  5. Ezex Accoom
    Ezex Accoom February 11, 2022 at 7:13 pm

    hi,

    I used this code to check address history if it is up to 5 years and when I created the form it worked, but if add the form to the Nested form the calculation stops working. How do I use it with a nested form to calculate and validate address history?

    Reply
    1. Samuel Bassah
      Samuel Bassah Staff February 12, 2022 at 6:10 am

      Hi Ezex,

      We’ll need to take a closer look at your setup to determine what’s wrong. If you have an active Gravity Perks License, you can get in touch with us via our support form with additional information. You may also want to try using our GP Date Time Calculator Perk for this functionality.

      Best

  6. Frederic
    Frederic February 9, 2022 at 2:19 pm

    Hi sir, Im all new to all wordpress and php stuffs. i need your help.

    i tried to use this and it doesn’t work at all for me. I copied the 2000 line code without any error following your guide. then i copied your new GWDayCount for the night count

    new GWDayCount( array( ‘form_id’ => 60, ‘start_field_id’ => 14, ‘end_field_id’ => 13, ‘count_field_id’ => 62, ‘include_end_date’ => false ) );

    i updated the functions.php and no error so far. i even rebooted the whole wordpress and server to be sure everything would work. This is the step i’ve done.

    1. on my website, i created 2 date picker. ​start date = id 14 – end date = id 13 i added a number field that need to show the number of night. the id is 60 i created another number field the for the count_field_id. the id is 62 when i press save form in my webpage and tried to choose 2 differents date to test, nothing happen is there something im missing to do somewhere? do i need to write something in the field setting of my form ? thanks a lot sir !
    Reply
    1. Dario Space
      Dario Space Staff February 9, 2022 at 2:35 pm

      Hi Frederic,

      If the setup is correct it should work as expected. You can try using Code Snippets plugin instead of modifying the functions file.

      If you have a Gravity Forms License, you can get in touch with us via our support form with an export of your form and any additional information so we can assist you further.

      Best,

  7. Ad
    Ad January 7, 2022 at 8:28 am

    Hi, when putting this code into FUNCTIONS.PHP I get the following error:

    Your PHP code changes were rolled back due to an error on line 34 of file wp-content/themes/uncode/functions.php. Please fix and try saving again. Uncaught Error: Class ‘GWDayCount’ not found in wp-content/themes/uncode/functions.php:34 Stack trace:

    0 wp-settings.php(546): include()

    1 wp-config.php(98): require_once(‘/home/sq49dtyo/…’)

    2 wp-load.php(50): require_once(‘/home/sq49dtyo/…’)

    3 wp-admin/admin.php(34): require_once(‘/home/sq49dtyo/…’)

    4 wp-admin/theme-editor.php(10): require_once(‘/home/sq49dtyo/…’)

    5 {main}

    thrown

    Reply
    1. Samuel Bassah
      Samuel Bassah Staff January 7, 2022 at 8:31 am

      Hi Ad,

      Based on the error message, it appears you’ve only added the configuration of the snippet and not the actual Class. Here is a link to the complete snippet.

      Best,

  8. Mikhail
    Mikhail June 27, 2021 at 2:52 am

    Is there any way to add 14 days to a specific date, but then return the new calculated date in a specific format? For example, date in one field is 6/1/2021 and I want to add 14 days but then have it return “June 15, 2021”

    Reply
    1. Samuel Bassah
      Samuel Bassah Staff June 28, 2021 at 6:25 am

      Hi Mikhail,

      We have a snippet you can use to modify and populate a Date field with the modified date. Here is the documentation to the snippet with details on the various options available. I would guess a configuration like this would work for you.

      new GW_Populate_Date( array(
          'form_id'         => 39,
          'source_field_id  => 40, 
          'target_field_id' => 7,
          'modifier'        => '+14 days',
          'format'          => 'F j, Y'
      ) );

      Best,

  9. Vitaly
    Vitaly May 14, 2021 at 7:16 am

    It seems to be working in functions.php file. However when I place it with my other snippets in a separate plugin, it brakes the website. Can there be something done?

    Reply
    1. Samuel Bassah
      Samuel Bassah Staff May 14, 2021 at 7:28 am

      Hi Vitaly,

      Since it works when placed in the function.php file, I don’t think there is an issue with the code. It could be with the way you’re inserting the snippet in the snippet plugin. If you have a Gravity Perks license, you can get in touch with us via our support form so we can assist you further. That said, here is documentation on how to install a snippet, to see if it helps.

      Best,

    2. Vitaly
      Vitaly May 14, 2021 at 3:45 pm

      Thank you for your time Samuel. Yes, the snippet works but, as I said, it breaks the website.

      1. Website is broken by simply disabling Gravity Forms plugin, even if it is installed in functions.php. I believe it would be fair to let people know this before they add it to their website.
      2. Website is broken when snippet is added in developer friendly plugin (from the link you just provided).

      Cheers,

    3. Scott Ryer
      Scott Ryer Staff May 14, 2021 at 4:42 pm

      Hi Vitaly,

      I’m unable to recreate this issue when I test it with the Code Snippets plugin.

      We recommend purchasing the Perk version of this snippet. Not only does it offer more features and ease of use, it also includes support.

  10. Alex Abrams
    Alex Abrams November 1, 2019 at 9:18 am

    Hi David, I’ve installed the ‘Calculate Number of Days Between Two Gravity Form Date Fields’ snippet and it was working wonderfully in Gravity Forms. However, we’re using Gravity Views and it stops the ‘Edit Entry’ screen from rendering and I don’t understand why. Have you run into this issue with your ‘GravityWiz’ plugin? All I’m doing is finding the days difference between the current date and the user’s data of birth. I’m using your ‘GW_Populate_Date’ snippet prior to the aforementioned snippet to populate the Current date and this appears to work correctly.

    Reply
    1. David Smith
      David Smith Staff November 4, 2019 at 7:34 pm

      Hi Alex, GravityView alters some of the core functionality of Gravity Forms when it renders forms in the Edit Screen. Unfortunately, we can only guarantee that our snippets will work with Gravity Forms proper. We have so many!

      Fortunately, this snippet has a plugin version that will work with GravityView. It’s called Date Time Calculator and it’s even easier to use than the snippet. If you give a shot, I’d love any feedback you have. 🙂

  11. RHYS COMLEY
    RHYS COMLEY October 17, 2019 at 11:34 pm

    Hello, how can i only return results greater than 5, i.e i only want to calculate days and return value greater than 5.

    i.e Start date 1st end date 7th returned value = 2 i.e Start Date 1st end date 5th returned value = 0 i.e Start Date 1st end date 3rd returned value =0

    i think i need to do a if statement, return value if greater than 5-5?

    Reply
    1. David Smith
      David Smith Staff November 4, 2019 at 9:58 am

      Hm, you could have two calculation fields with the same formula and then use conditional logic to show/hide the second calculation field if the value was greater (or less than) 5. Then you would only use the second calculation field’s value.

  12. Laras
    Laras September 18, 2019 at 10:09 pm

    what if the opposite. I have a member data that entered the x date with a validity period for y months. What date will the membership end. What plugins or GW solutions are suitable for the solution?

    Reply
  13. ET
    ET September 8, 2019 at 9:38 pm

    I’m not a programmer, but I manage to insert the code to my child theme functions.php, and had modify the Form ID and Field ID as accordingly

    But after that I do not know what to do.

    On My Gravity Form itself I had 1. Start Date (Date Field) 2. End Date (Date Field 3. Duration (Text Field)

    at the Duration Field I checked “allow field to be populated dynamically” then enter the parameter field as “GWDayCount”

    Am I doing it correctly?

    Reply
  14. Ido
    Ido July 11, 2019 at 8:29 am

    thanks! works great – but I have the same question as Robert: I want to calculate years and not days. How do I do that? Basically I’ve set the “start_field_id” to a “birth date” field, and the “end_field_id” to a date field with default value of “{date_mdy}” – so I get the calculation between the birthday and today – but i get it in days, whereas i want it in years. is this done via the Gravity Forms Date Time Calculator perk? and if so – how and where do i get this perk? it’s not on the perks list. thx!

    Reply
    1. David Smith
      David Smith Staff July 11, 2019 at 10:01 am

      You could always divide that number by 365. Results may not be 100% accurate but they’ll be pretty close. The Gravity Forms Date Time Calculator perk handles this a little more robustly. This early access perk is available by request to any Gravity Perks customer. ?

  15. Robert
    Robert July 3, 2019 at 2:48 pm

    Hi David, thanks for this info. Could I use this code to calculate age (today minus date of birth)?

    Thanks.

    Reply
    1. David Smith
      David Smith Staff July 10, 2019 at 8:45 am

      Sure. Or if you’re a Gravity Perks customer, just request the Gravity Forms Date Time Calculator perk which includes an :age modifier for calculating this with a single date field.

  16. Peter Muir
    Peter Muir July 1, 2019 at 9:24 am

    So this is a bit of an odd one… it works perfectly until I enable Partial Entries. Once I do that the window.gwdc script is moved to before the opening html tag.

    Reply
    1. David Smith
      David Smith Staff July 1, 2019 at 6:24 pm

      Hi Peter, this is unlikely something we will fix in the snippet-version of this; however, we do have an early-access perk called GP Date Time Calculator that offers a far superior solution. It’s available to any Gravity Perks customer by request.

  17. rf
    rf June 22, 2019 at 5:46 pm

    Hi, this works great. Do you have any suggestions on changing the date for datepicker 2 if datepicker one becomes the same or greater than datepicker2?

    Gravity forms article section: 4. Datepicker 1 + 1 month becomes minDate for datepicker 2 suggests how to make date picker 1 the minimum for datepicker 2 but this breaks the counter if say you set the two date pickers and then move datepicker 1 backwards because datepicker 2 will change. Here’s the article for reference.

    https://docs.gravityforms.com/gform_datepicker_options_pre_init/#3-datepicker-1-becomes-mindate-for-datepicker-2

    Reply
  18. Christoph
    Christoph June 13, 2019 at 5:04 pm

    Hi,

    we are getting the following error when trying to install the snippet in the child theme’s function.php:

    Uncaught Error: Class ‘GWDayCount’ not found in wp-content/themes/oceanwp-child-theme-master/functions.php:32 Stack trace:

    0 wp-settings.php(499): include()

    1 wp-config.php(90): require_once(‘/homepages/26/d…’)

    2 wp-load.php(37): require_once(‘/homepages/26/d…’)

    3 wp-admin/admin.php(34): require_once(‘/homepages/26/d…’)

    4 wp-admin/theme-editor.php(10): require_once(‘/homepages/26/d…’)

    5 {main}

    thrown

    Any idea how to troubleshoot this one?

    Reply
  19. Simon Vetterli
    Simon Vetterli June 7, 2019 at 12:35 am

    Hi

    I did this, all looking fine for me. My next step is, that I have prices for a service, and they vary depend of the amount of days.

    Any idea, how is the best way to calculate and get a number, where the amount per days is vary?

    Regards,

    Simon

    Reply
  20. Esther Gloria
    Esther Gloria May 28, 2019 at 5:40 pm

    Hi, how do i add to two separate forms? I attempted to just add another line of this text :

    “new GWDayCount( array( ‘form_id’ => 5, ‘start_field_id’ => 4, ‘end_field_id’ => 8, ‘count_field_id’ => 31, ‘include_end_date’ => false ) );”

    Changing the form id, but it isn’t working on the new form. Am I doing something wrong?

    Reply
  21. Esther
    Esther May 24, 2019 at 10:35 pm

    Hi this now gives a pluggable error when implemented in functions.php file. Any chance you have a fix for this?

    Reply
    1. Esther Gloria
      Esther Gloria May 28, 2019 at 5:35 pm

      Actually, it was being caused because of the tags within the code. I replaced it with an enqueue script function and called a separate file with the script.

  22. Valerie Gallagher
    Valerie Gallagher May 24, 2019 at 4:00 pm

    What type of field do I need to use to make this work? I tried with a number field but it is not populating.

    FYI, I purchased the 1 perk package (conditional dates) if that has anything to do with it.

    Reply
    1. Valerie Gallagher
      Valerie Gallagher May 24, 2019 at 4:02 pm

      Actually, sorry. It is working with the number field. I forgot to clear my cache. Sorry!

  23. hammal
    hammal May 23, 2019 at 5:02 pm

    I want to know if this works with what im trying to do is.

    when a customer select a start date and end date it checks the month if its from january to january then it charges $80 if the date is between january to february then is should charge 80+70 and so on.

    would I be able to do something like this with this ?

    Reply
    1. David Smith
      David Smith Staff May 23, 2019 at 10:14 pm

      Does it actually matter which months or are you just attempting to calculate the number of months and then the first month is $80, second month is $70, third month is $60, and so on?

  24. ivonne
    ivonne May 22, 2019 at 7:30 am

    Hi, I’m stuck at this step

    Once you instantiated the class you are finished! If you would like to have this functionality on multiple forms then just create a new instance of the class and fill in the parameters for the new form. That’s it!

    What does it mean to instantiate the class?

    Reply
    1. David Smith
      David Smith Staff May 22, 2019 at 9:39 am

      Hi Ivonne, instantiate is a big word but all it means is that you’ll be creating a new “instance” of the GWDayCount() class with a set of parameters (aka options) for that specific instance. See the “Standard Usage” usage example.

  25. Mou
    Mou May 14, 2019 at 6:08 am

    Hi,

    The snippet works great. But the jQuery script (i.e. window.gwdc) gets added at top of the HTML before DOCTYPE when the gravity form is loaded in a popup using any plugin which throws jQuery not defined error. Do you have any solution for that?

    Thanks, Mou

    Reply
    1. David Smith
      David Smith Staff May 14, 2019 at 12:10 pm

      Hi Mou, we have made some improvements to how we load scripts in snippets but they have not been implemented here. If you have any PHP experience, here’s an example of how the scripts should be enqueued: http://snippi.com/s/1dj9jke This snippet is in the queue for an update. No definite ETA.

  26. Sean Lee
    Sean Lee May 6, 2019 at 1:59 pm

    Is it possible to calculate the range between two dates and recalculate the subtotal at checkout page? Yes, we are trying to use it as a simple booking system.

    Reply
    1. David Smith
      David Smith Staff May 6, 2019 at 3:01 pm

      This snippet would allow you to calculate the number of days between two dates. You could use that in a Product calculation field to calculate a product price based on that number.

    1. David Smith
      David Smith Staff February 25, 2019 at 9:16 am

      Hi Ruairi, Date Time Calculator supports calculating weekdays and weekendDays between two dates but does not support calculating the number of a specific day.

  27. shane jackson
    shane jackson February 20, 2019 at 10:32 pm

    Hi, How do I use this? Not sure I understand the below. Is there an example?

    How do I use this functionality? To use this snippet’s functionality just go directly below the snippet and instantiate the GWDayCount() class. Instantiate is a big word but all it means is that you’ll be creating a new “instance” of the GWDayCount() class with a set of parameters (aka options) for that specific instance.

    Not understanding the above.

    Reply
  28. Tal
    Tal February 12, 2019 at 9:06 am

    Dear David

    Thanks for the code!

    1. I get an error when trying to save the functions.php file… Can you kindly help me understand what’s went wrong?

    ” Uncaught Error: Class ‘GWDayCount’ not found in wp-content/themes/oceanwp-child/functions.php:25 “

    1. I didn’t seem to understand what kind of field I should use in the form that will populate the result.

    Best Tal

    Reply
    1. Tal
      Tal February 13, 2019 at 9:43 am

      Thanks David Your link helped me see where I had a mistake. But, I now have another problem implementing it… Is it possible to pay for this days ability only? (we really don’t need the rest of the really awesome ‘perks pack’, and also trying to keep the website lean as possible). Tal

    2. David Smith
      David Smith Staff February 13, 2019 at 12:00 pm

      Hi Tal, it sounds like you need the Basic package which gives you access to one perk on one site. You never have to worry about leanness with Gravity Perks because you only install the perks you need.

  29. Drs. Andor Demarteau
    Drs. Andor Demarteau February 11, 2019 at 2:17 pm

    David, I’d like to use this snippet to calculate the difference between two dates: – today – start of an event date I will not use date picker fields as the second date is set and will (in a later form update) be populated using your populate anything perk as it is taken from a clan calendar plugin. Do you have a version of this snippet that works with regular date fields in this manner?

    Reply
    1. Drs. Andor Demarteau
      Drs. Andor Demarteau February 12, 2019 at 12:32 am

      Ignore the above request. It seems that using the date picker format makes it easier to populate the field dynamically as one input is provided (as opposed different year, month and day fields when the date type is selected). Only weird thing is that apparently a separate filter setting is required to make a datepicker actually read-only when using the relevant perk.

    2. David Smith
      David Smith Staff February 12, 2019 at 6:06 am

      Yes, readonly only applies to the manual user input (just like in your browser) by default. Javascript is able to interact with inputs regardless of the readonly attribute so an additional filter is required if you want to disable the datepicker.

    3. Drs. Andor Demarteau
      Drs. Andor Demarteau February 12, 2019 at 6:17 am

      David, okay thanks for the explanation. I’ll drop the relevant code in my snippets plugin items (nice alternative for functions.php which gets overwritten on theme update or having to struggle with child themes tec.)

  30. Michael George
    Michael George February 7, 2019 at 3:05 pm

    David,

    What I want to do is a little complex. Or at least it is for me. I am, sadly, not a coder.

    I want to notify our clients as to when their stuff will be ready. I want to take today’s date and add 21 days to it.

    I want to have something at the bottom of the form, before they submit, that says “Your documents will be created on or before 3_weeks_From_Today”

    Ideally, I would have a single radio button or checkbox that says “I understand my documents will be ready on variable_date.”

    But I realize that’s a probably a tall order!

    Any feedback is greatly appreciated, even if its: “Hire a coder!”

    Thank you in advance.

    Reply
  31. James
    James January 2, 2019 at 9:16 pm

    For my project, I needed to modify the code slightly because the javascript being output in this function “function load_form_script( $form )” was preventing my redirect at the end of my form.

    (I’m using Gravity Forms to generate a custom product and add it to the cart – without ajax – and then redirecting to the cart upon completion of the form).

    The solution was to remove the entire chunk of javascript (line 50 to 142) and put it inside the form in a HTML block.

    I also cleaned up the PHP by removing the “self::$script_output = true;” both above and below where the javascript was, and not more “can’t modify headers” error after submitting my form.

    Hope this helps others who run into this issue.

    Reply
  32. Robbin
    Robbin January 1, 2019 at 7:17 am

    When I add the code into my functions file, WordPress get the white screen of dead. Are there some changes needed for WP5?

    Reply
  33. Alfonsas
    Alfonsas November 25, 2018 at 9:17 pm

    Thanks for this solution.

    I’m trying to get a calculation of age (of a person) from date of birth working. It calculates it in days, which is not ideal ;)

    At the moment, I then use a hidden field with a current date, and date of the birth date picker. Then I use a field with a calculation a formula (age-in-days)/365.25, but this is not quite accurate.

    Any chance you could guide me through this?

    Many thanks in advance!

    Reply
    1. David Smith
      David Smith Staff November 28, 2018 at 12:00 pm

      We recommend our GP Date Time Calculator early-access perk for this. It provides an “:age” modifier for any Date field so you can accurately calculate age. If you’re a Gravity Perks customer, drop us a line via the support form.

  34. Darren Rollandi
    Darren Rollandi October 11, 2018 at 6:53 am

    Hello ive added the snippet to my functions.php file, i dont recieve any errors. it does not work. PLease assist.

    Reply
    1. David Smith
      David Smith Staff October 10, 2018 at 11:45 am

      This is possible with a special merge tag provided by our Early Access perk, GP Date Time Calculator. This perk is available by request to any Gravity Perks license holder.

  35. Ivo Kittel
    Ivo Kittel June 20, 2018 at 4:35 am

    Hi, this script works 100%! Thank you. I also just purchased the Date Limit perk. Have however run into a bit of a problem now as I need this to work with more than one date range, as I have multiple date ranges that are presented to the user based on their initial selections. Any chance you have a solution for that?

    Reply
  36. karim
    karim June 7, 2018 at 6:58 am

    Hi David, how can i call the GWDayCount function inside a form so that i dont need to do changes again and again in Functions.php , is there any way that i can use that call the class within the Form?

    Reply
    1. David Smith
      David Smith Staff June 8, 2018 at 8:27 am

      Hi Karim, if you’re looking for a UI, I would recommend our early access GP Date Time Calculator perk which makes doing this a breeze. If you’re interested, pick up a copy of Gravity Perks and drop us a line via support.

  37. Aby
    Aby June 5, 2018 at 3:26 am

    Dear David –

    My client offers services. The rate for the service goes down with how the delivery time increases. For urgent service, in 4 hours, the rate is highest – then the rate tapers in 4 hour intervals as the delivery time chosen is furthened. Been through all your literature it seems.

    Will your “GP Date Time Calculator” help me build something using SIMPLE gravity form date and time fields, with merge tags, that allows the customer to choose a date and time of delivery…subtracts the hidden field of the date/time of ordering the service, and based on simple conditional logic, given the number of hours, selects the appropriate EDD product?

    This is all theoretically straight forward.

    Thanks … and eager!

    Reply
    1. David Smith
      David Smith Staff June 5, 2018 at 3:45 am

      I don’t know how the EDD product integration works but you could certainly use GP Date Time Calculator to calculate the number of hours between a current time and a future time and then use conditional logic to show/hide fields based on that number.

  38. Salman Yamani
    Salman Yamani February 2, 2018 at 5:38 pm

    Hi David, After I bought GP and got the Date Time Calculator from Mr. Jordan Smith, I tried the attached special shortcode and worked fine in the number field. However, the issue is when I submit the form I got only number 1 instead of the right calculation results.

    Reply
    1. David Smith
      David Smith Staff February 2, 2018 at 9:19 pm

      Hi Salman, if you haven’t already, drop us a line via support. We’ll be happy to sort this out for you. :)

  39. bluantinoo
    bluantinoo January 19, 2018 at 7:39 am

    Hello David, the script is just awesome, but I have a weird issue on Yoast page-sitemap.xml.

    in some way, the js loaded with the load_form_script function, is injected at the beginning of the page-sitemap.xml, breaking it.

    URL: view-source:https://www.greenparkmadama.it/page-sitemap.xml

    I really have no clue on how this can happen! Anyone can replicate this issue?

    Reply
    1. David Smith
      David Smith Staff January 20, 2018 at 7:25 pm

      Hi Bluantinoo, we’re not able to provide support for 3rd party plugins with our snippets; however, if you’re a Gravity Perks customer, we’ll be happy to provide additional support via the support form. I would strongly recommend the GP Date Time Calculator for this functionality anyways. No touching code and the plugin is well supported.

  40. Joel McDonald
    Joel McDonald January 16, 2018 at 5:43 pm

    Fantastic! Worked like a charm! Even was able to edit to allow for negative numbers as a result (needed to check for pre-sale deadline on form). Why GF doesn’t build in logic/calculations for dates is beyond me.

    Reply
  41. sven
    sven December 15, 2017 at 6:22 am

    Hi David, I installed the GP Date Time Calculator, but cannot see an option for the calculation in my form. Which field type do I need to use for the calculation? Thanks for your help.

    Reply
  42. Asam Ali
    Asam Ali October 1, 2017 at 11:58 am

    Using this snippet and adding the value to a ‘amount’ filed which is multiplied with the product field (booking/rental calculation) is working fine on the website, but when confimation emails are sent out, the calculated price is ALWAYS 0. When removing the data calculation, everything seems right again in the email? Any quess why?

    Reply
    1. David Smith
      David Smith Staff October 3, 2017 at 7:36 am

      I’m not able to recreate this issue. We have an early-access plugin that can handle this functionality called GP Date Time Calculator. Pick up a copy of Gravity Perks and drop us a line via support form if you’d like to take it for a spin.

    1. David Smith
      David Smith Staff September 30, 2017 at 1:46 pm

      I confirmed that this snippet is working. If you’re looking for a codeless solution, we have an awesome early-access perk called GP Date Time Calculator which can make this task much easier. Pick up a copy of Gravity Perks and drop us a line via support and we’ll be happy to send you a copy. :)

  43. Adrian
    Adrian September 26, 2017 at 8:32 pm

    I have added this code and all is working well when I use the form “preview” but when I load the form onto a page it is not showing the calendar drop down at all for selecting dates.

    When I inspect element it is showing this error: Uncaught ReferenceError: jQuery is not defined

    and also this: Uncaught ReferenceError: gwdc is not defined

    Really appreciate any help you can give me :)

    Reply
  44. paolo
    paolo September 21, 2017 at 1:37 pm

    Hi david, after last wordpress updated I get this error when I click on button to confirm the form.

    This error only with the forms that use this script…how to fix it?

    Thank you!

    Reply
    1. paolo
      paolo September 21, 2017 at 1:40 pm

      This is the error:

      Warning: Cannot modify header information – headers already sent by (output started at /home/myrecept/public_html/wp-content/themes/Divi-child/functions.php:65) in /home/myrecept/public_html/wp-includes/pluggable.php on line 1210

    1. David Smith
      David Smith Staff September 18, 2017 at 10:00 pm

      Hm, that should work. Here is what I used to get it on the demo form (see top of article): var days = jQuery( '#input_16_4' ).val();.

  45. Vince
    Vince September 15, 2017 at 7:02 am

    Can not get it working. I made a plugin from the code but the number of weeks is not working

    Have a arrival field (id4) departure field (7) and want to use the weeks (field id 10) for calculating rent. form id=1

    Reply
    1. David Smith
      David Smith Staff September 18, 2017 at 10:02 pm

      Hi Vince, hard to say what isn’t working but if you’re a Gravity Perks user, we have an early-access plugin called GP Date Time Calculator that makes calculations like this easy right in the form editor with any calculation-enabled field (no code required). Drop us a line via support.

  46. paolo
    paolo September 4, 2017 at 6:08 pm

    Hi david, I bought your perks and I use this script but I have a question about it…I would use this with 2 or more gravity forms, how to add the second form in the follow code?

    Thank you!

    Reply
  47. Sam
    Sam August 3, 2017 at 2:33 pm

    Hi David,

    Thank you for this nice snippet.

    Can you please also advise how can we show a third field as a dropdown with list of number from 0 to the end number is equal to the difference between the two dates?

    I have restricted the second date field to not give permission to user to select more than 60 days date based on the date entered in first date field.

    Thanks, your help will be really appreciated.

    Reply
    1. David Smith
      David Smith Staff August 12, 2017 at 6:22 pm

      Hi Sam, this is not readily possible out-of-the-box. You’d need to write some custom code to add those options dynamically any time the number of days changes. I don’t really have a walk-through for this one.

  48. Rawad Merhi
    Rawad Merhi July 16, 2017 at 9:05 am

    I got it working, however, how would I hide the number field? As you can see in the demo the number field is already displayed, I want it hidden until the dates are selected? How would I be able to accomplish the task you have in the demo.

    Your help would be appreciated.

    Reply
    1. Rawad Merhi
      Rawad Merhi July 16, 2017 at 3:17 pm

      Hello David,

      Thank you for the quick response. I believe the JQuery date picker isn’t featured yet, meaning I can’t accomplish the task. I’m using the JQuery Datepicker fieldset.

      I look forward to your response.

  49. Sam Mitzmann
    Sam Mitzmann July 10, 2017 at 3:44 pm

    Is there a way to use this snippet to calculate a persons age based on their date of birth input and the current date? I would want their current age to go into a field on the form so I can use it as a conditional rule for other fields.

    Reply
  50. Rawad Merhi
    Rawad Merhi June 17, 2017 at 5:23 pm

    I added the code you provided to the function.php file and it crashed my site. I have the code listed below, Your help would be truly appreciated.

    Reply
  51. Dominique
    Dominique April 4, 2017 at 9:28 am

    Hi David,

    We would like to use this functionality for a calculation for Car Rental. There is a special rate for single days, weeks and full weekends. Can you adjust the plugin (we can pay for that) so it functions like this form: http://bit.ly/2nY9uPx ?

    Thanks in forward!

    Reply
  52. Wessel
    Wessel February 25, 2017 at 5:53 am

    Hi, great snippet!

    However, I think I’m messing something up. My form disappears when using the snippet as the CSS goes to “display: none;”. It works fine when displaying the form in a pop-up from pop-up maker. Changing the display to block makes the form visible but the calculations do not work.

    The form: http://topsportacademy.com/camp-planner/

    Thanks!

    Reply
    1. David Smith
      David Smith Staff February 25, 2017 at 9:03 am

      Hi Wessel, it looks like the actual JS script is not being included for some reason. We have a better solution for this with GP Date Time Calculator. It is available by request for Gravity Perks license holders.

  53. Darrin
    Darrin February 22, 2017 at 2:34 am

    I’m looking for a method to calculate the number of hours between 2 or 3 sets of times within a period. For example, creation of a time sheet.

    Goal is to calculate: Advanced Field: Time (1) | Advanced Field: Time (2) | Advanced Field: Time (3) | Total Start Time End Time Break # of hours 8 AM 6PM 1 PM 9

    What is the best way to go about doing this? I’ve noted a variety of links that could possible help get me there: (i.e.) https://github.com/soulseekah/gravityformstimesheet – But I need more clarification & guidance on what to do.

    Can you help on this?

    Reply
    1. David Smith
      David Smith Staff February 25, 2017 at 9:08 am

      If the Time fields are separate fields and not part of a List field, you could use GP Date Time Calculator to calculate the time differences between each. It is available by request for Gravity Perks license holders.

  54. dubyajay
    dubyajay February 13, 2017 at 11:55 am

    Hi, First, thanks for this snippet! In a recent update of wordpress and/or gravity forms the datepicker on my form started using the date format from the site instead of the date format from the form.

    Since the date format from the site was Month dd, yyyy (or F j, Y ) the difference between dates couldn’t be calculated, I assume because of the text in the format.

    When I switched the date format for the site in the wordpress “Settings” to mm/dd/yyyy the dates in the form were able to be calculated. I contacted gravity forms and they said it was a snippet issue so now I’m contacting you. Any idea on why the date format of the site is overriding the date format of the form?

    The site is using the latest version of wordpress and gravity forms. Also, I updated the code of the snippet to latest version sometime early last year.

    I’d give you an example site but it’s a live site and it’s currently “fixed”. I would like to be able to use a different date format for the site than for the form tho. I currently can’t do that and have the form function properly with the calculate days snippet at the same time. If you can’t replicate the issue, I could set up a form on a test site to show you but I’d prefer to share the site address offline if possible.

    Any help or advice is greatly appreciated.

    Thanks in advance!

    Reply
    1. dubyajay
      dubyajay February 13, 2017 at 1:03 pm

      Thanks for your quick reply! My issue isn’t non-us date formats. It’s having one date format in the WordPress settings and a different format in the gravity form datepicker field. It is defaulting to the WordPress format. If I want wordpress to format as Month dd, yyyy and then have the gravity form datepicker field to be mm/dd/yyyy it defaults to Month dd, yyyy which cannot be calculated. Could you test that?

    2. David Smith
      David Smith Staff February 13, 2017 at 1:05 pm

      Hi Dubygay, the WordPress format should not be impacting your Date fields. Make sure you’re running the latest version of Gravity Forms.

    3. dubyajay
      dubyajay February 13, 2017 at 1:13 pm

      Yes, I know it shouldn’t affect it but the only way I could get the calculate days snippet to work is to change the wordpress date format to match the one inthe form datepicker.

      I’m running latest wordpress and gravity. I’ve been using this snippet for several years and it’s worked great. Something changed in either wordpress or gravity the last week or so to make the date in gravity misbehave.

      I contacted gravity forms about this (I have a developers license) and they said it’s a gravity wiz issue. That’s why I’m contacting you.

    4. David Smith
      David Smith Staff February 13, 2017 at 1:36 pm

      I’m not able to recreate this issue. The demo site’s default date format does not match that of the field’s. Our recommendation is to pick up a copy of Gravity Perks and send us a request for GP Date Time Calculator which handles this functionality without code via the support form. We are better able to support our paid-for products.

  55. Edgar
    Edgar February 9, 2017 at 7:37 am

    Hi David, Thank you for posting this code! Now I read this I think maybe you can help me.

    I see the GP Date Time Calculator demo, I just do not see how I can buy it. I will explain my situation: I have a car rental company and I use a form of Gravety Forms, A good product, but I can not do everything with it what I want.

    I want to specify that I have a PickUp day and a DropOf day. 1. First, you can select a date that has already passed, that I can’t set the hours is not very important. I count each day from 09:00 to 08:30 next day, for 1 dag/ night. I saw that this was possible with “GP Date Time Calculator” Now next: I have different rates if they rent for one day than X amount cost per/day, At 2 to 4 days an X amount, at 4 to 7 days a x amount per/ day… you know what I mean.

    We also rent loose products with it for the x amount of days, such as GPS, child seats and insurance. etc. Does the add-on support this option too?

    It would be nice to have an option to set a minimum number of days required: for example, you can select at least for 2 days?

    I wondered if you would be willing to give me any pointers on how to make Thank you again!

    I’m not very technical, but I building my site by myself.

    I have tried other pugins like: RnB – WooCommerce Rental & Booking System. But I did not work like i wanted, it was not well thought out. I think GRAVITY FORMS is a trusted party, And all they offer works well.

    Can you do something for me? Thank you in advance

    Reply
  56. strand
    strand October 21, 2016 at 9:54 am

    okay so ive added the code to my functions.php file and i have two date fields, followed by a hidden field. How do i get the value into the hidden field? Am i missing a step? Do i need to set anything in the hidden field / date fields in the form settings? Does the gravity wizz plugin need to be installed for this to work as i haven’t purchased this?

    Thanks

    Reply
  57. Giacomo Papasidero
    Giacomo Papasidero September 25, 2016 at 2:21 am

    Hi David, i want to use this snippet to calculate day from the user registration date. So i want to populate the first date field with user registration date. I try to use user_registered, but also if i see the correct date, this format doesn’t work with your snippet. Can help me? I want to limit the form only for users that are registered for more than a number of days :) Thanks Giacomo

    Reply
    1. David Smith
      David Smith Staff September 27, 2016 at 12:07 am

      Hi Giacomo, you’ll want to use the gform_field_value filter to create a custom dynamic population parameter (more information).

      Your function will need to fetch the current user:

      $user = wp_get_current_user();

      And get the registered date:

      $reg_dat = $user->get( 'user_registered' );

      And then convert that date to a compatible format:

      $reg_dat = date( 'm/d/Y', strtotime( $reg_date ) );

    2. Giacomo Papasidero
      Giacomo Papasidero September 27, 2016 at 1:14 am

      Ok, Works :) But in the code, the last row, you had insert “dat” instead “date”. The correct code is

      $reg_dat = date( ‘m/d/Y’, strtotime( $reg_dat ) ); So the code works for me. It’s correct?

  58. Brad
    Brad September 9, 2016 at 1:49 pm

    David,

    Thank you for posting this code! It was a great help to me.

    I wondered if you would be willing to give me any pointers on how to make this script work with any form without setting the form and field values when calling GWDayCount(). I am duplicating the same form on several pages, and cannot set the id’s each time a new form/page is created.

    Each starting, ending, and counting field in my forms have a unique class associated with it. I was trying to use that custom class to find the id’s dynamically.

    Thank you again!

    Reply
    1. David Smith
      David Smith Staff September 10, 2016 at 9:02 am

      Hi Brad, you might be interested in giving GP Date Time Calculator a try. It is merge tag based and since field IDs won’t change when duplicating a form, the configured field (for counting days) would just work on duplicated forms. If you’d like to take it for a spin, just pick up a copy of Gravity Perks and drop us a line via support.

  59. Bob
    Bob June 10, 2016 at 4:54 pm

    Hello my friend, thank you for useful code, I have a problem, I want my user give his/her passport expire date and then the form calculate if it has 6 months valid time or no. I put start date : the expire date which user select via date picker and the end date : another date picker which in advance tab I set Default Value to {date_dmy} and other field for calculation result, but when I calculate it for example today : 10/06/2016 and the expire date: 11/06/2016 the result is : 118 ! for 12/06/2016 the result is 117. I didn’t give the URL because of it is not in English it is Persian but if you want to take a look I will update you with URL. Do you have any idea what is going on? Best wishes Bob

    Reply
  60. Daniel
    Daniel June 1, 2016 at 2:36 pm

    I have a hidden field that is getting the count just as it should. But I’m trying to use conditional logic to show another field based on the number of days. So for example show this field if days is more than 2. That’s not working. I can see the days hidden field gets set to the correct number which is more than 2 but the field with conditional logic never shows up.

    Thanks for your help.

    Reply
    1. David Smith
      David Smith Staff June 30, 2016 at 10:05 am

      Hi Daniel, could you send me an export of your form and a copy of your configuration of the snippet?

  61. Oleksii
    Oleksii June 1, 2016 at 10:00 am

    Great! Thank’s a lot!

    Now I want to calculate number of hours between two dates (or just calculate day as 24 hours). How can I add the calculated number of hours between start timestamp (merge date field and time field) and end timestamp (merge date field and time field). Please advice.

    Reply
    1. David Smith
      David Smith Staff June 30, 2016 at 10:06 am

      This is not possible with this snippet; however, it is possible with our GP Date Time Calculator plugin (available by request to Gravity Perks users).

  62. Frances
    Frances May 17, 2016 at 3:35 am

    Hi, I’m new in using gravity form and I finally make this two entry of dates work. Now I want the total value of this date to be multiplied to a custom number calculation field and tally the total to the pricing field before submitting to be check out for the shopping cart.

    How can I add the calculated number field to the pricing field total value before submitting the check out button? Is there any back end customization for this logic. Please advice.

    Reply
    1. David Smith
      David Smith Staff May 18, 2016 at 9:49 am

      Hi Frances, you can create a Calculated Product field. It will allow you to set the product price based on a formula. Use the whichever field is populated with the number of days in this formula.

  63. A Ghatit
    A Ghatit April 21, 2016 at 5:20 pm

    Hi, I’m wondering if something is possible… I have the GP Date Time Calculator Version 1.0.beta2.0, and GP Limit Dates Version 1.0.beta1.9. This is what I’d like to do…

    If someone fills out a Gravity Form before noon, then they can select the next day, or the day after in the date picker. But, if it is after 12 noon, it is equivalent to the next business day and they can only choose + two days or + three days from today’s date. Is that possible?

    Thanks.

    Reply
    1. David Smith
      David Smith Staff April 21, 2016 at 10:50 pm

      Hi A Ghatit, you would need two separate Date fields. One with the ability to select next day and one that is the + 2 days from current date. You can then use conditional logic to show/hide these fields based on the time. Since the Time is not available in conditional logic yet, you can use GP Date Time Calculator to get the selected time in numeric format like so (screenshot). You would base the conditional logic on the value of this field.

    2. A Ghatit
      A Ghatit April 22, 2016 at 9:23 am

      Thank you for the response. That makes perfect sense, and I can work with that. One question… In your example you have this calculation: {Time:10} – {today}. Do you created a Time field on the form (field 10), but how did you set it so that it defaults to the current time? I don’t see anything obvious. Do I need to add something to functions.php?

      Thanks.

    3. A Ghatit
      A Ghatit April 22, 2016 at 9:50 am

      Sorry – one other question… For the calculation, I need to exclude weekends (just count business days). I know how I can limit to just weekdays using GP Limit Dates, but the calculation itself will still include the weekends. So, if I’m saying you can go +1 for the minimum date and +3 for the maximum, and today is Friday, since the weekend is excluded, the customer should be able to choose Mon, Tue, & Wed.

      Is there a way to do that?

      Thanks.

    4. David Smith
      David Smith Staff April 22, 2016 at 10:54 am

      The {today} merge tag is a special merge tag available with GP Date Time Calculator for use in calculations. It is replaced by the current date at 00:00. If you subtract the entered time from the {today} value, it will give you the entered time in hours (based on today).

      There is another special merge tag available with GP Date Time Calculator that allows you to calculate weekdays or weekends.

      {weekdays:{StartDate},{EndDate}}

      A real example from one of my forms:

      {weekdays:{Check-in:15},{Check-in:16}}

    5. A Ghatit
      A Ghatit April 22, 2016 at 11:16 am

      Thank you, again. You mention subtracting the entered time. Instead of calculating from a user-entered time, I want to somehow calculate the current time, without the user having to enter the current time. Is there something similar to {today} that will give me the current time?

      My use case is basically I want to have a user-entered date field, and if the person brings up the form before noon, they can select +1 or +2 days (excluding weekends). If they bring up the form after 12 noon, they can select +2 or +3 days (excluding weekends). I understand from the previous response that I will have two date fields that I will conditionally show based on the calculated number field, but for the calculated number field, I need to somehow get the current time and subtract it from {today} to determine if it is before 12 noon or after.

      The {weekdays:..} calculation would help if I needed to count the number of days between two dates, but I really just want to restrict the +1 and +2 parameters in the GP Limit Dates plugin to just count weekdays.

      Thanks.

    6. David Smith
      David Smith Staff April 22, 2016 at 4:01 pm

      Sorry, A Ghatit, I may have wasted your time here. I tried to see if there was a way to accomplish this but the functionality just isn’t there. If this is something you’d like to commission, I’d love to talk more about it. Get in touch.

  64. Soso
    Soso February 22, 2016 at 9:35 am

    Hello Devid,

    Thanks for this helpful article!

    I have a question: I would like to limite the date range of the first picked to “today” and second from first not more than 100 days?

    Thanks!

    Reply
    1. David Smith
      David Smith Staff March 8, 2016 at 10:52 pm

      Not sure what you mean about the price field; however, you can hide the number of days field by adding the “gf_invisible” class to the CSS Class Name setting in the field settings for that field.

  65. Missy
    Missy January 8, 2016 at 1:04 pm

    Great snippet, was wondering if there might be a way to vary this a bit….

    I have a case where I would like to add 30 days to the date of submission (timestamp) and then use that as a merge tag in an email.

    Basically, we want to issue a coupon in the notification email, that would have an expiration date of 30 days from form submission.

    Thanks for any insight!

    Reply
  66. A Ghatit
    A Ghatit December 25, 2015 at 4:08 am

    Hi – 2 questions.

    I have a license for Gravity perks. Can I get the GP Date Time Calculator plugin? Also, is there a way to exclude weekends from the calculation?

    Thanks.

    Reply
  67. Serge
    Serge December 9, 2015 at 2:21 am

    Love the plugin Here is where we used it http://saigonbbqs.com/rent-hire-bbq-grill-saigon-hcmc-vietnam/

    2 questions – the field that results in the number of days. When I tried to make it hidden in Gravity Form settings, the calculations stopped working. Now I hid it via CSS and it works. Was there something special I had to do to use it as a hidden field

    • If I have 2 forms on the site that can use this calculation, is there a way to do that?
    Reply
  68. Stepan
    Stepan December 7, 2015 at 7:59 am

    Hi David, thank you for the great solution! It works fine, I have even expanded it a bit – needed to create something like booking form with highseason fee, so I used your solution and added two more days there – high season start and high season end… but I’m not very good programmer, so I still have question :) How do you think, is there a possibility to add backwards compatibility for these fields ? What I mean – user selects start date and end date. after that, he can see number field with quantity. So here is the question – can we change end date if user manualy changes quantyty field?

    Reply
    1. David Smith
      David Smith Staff November 29, 2015 at 10:50 am

      There are two methods:

      1. You can populate the Number of Days into a Quantity field which will then be multiplied by the associated Product price.
      2. You can populate the Number of Days into a Number field and then use that Number field in the formula of a Calculated Product field.
    2. Shahaf
      Shahaf November 30, 2015 at 2:23 am

      I tried the number solution but it didn’t work. for some reason the date fields are not in the formula insert merge tag. and in the quantity field the enable calculation is not there. what I’m doing wrong?

    3. David Smith
      David Smith Staff December 1, 2015 at 6:59 am

      Hi Shahaf, you do not need to enable calculations on the Quantity field for solution #1. Just set the field ID of the Quantity field as the “count_field_id” parameter in the above snippet and the snippet will handle doing the day count calculation and populate that number into the Quantity field.

  69. Johan
    Johan July 17, 2015 at 4:44 am

    Hey David,

    Just wondering: what if I would like this functionality not in multiple forms, but in one form on multiple different fields? Tried to make it work, but didn’t work…

    Regards,

    Johan

    Reply
  70. Johan
    Johan July 13, 2015 at 6:16 am

    Hey David,

    Same problem as Raymond here, but unfortunately I can not remove the {date_dmy} as I use that to auto-populate a hidden field to use as start field. Do you have any idea how to solve it?

    Thanks in advance,

    Regards from Amsterdam,

    Johan

    Reply
    1. Johan
      Johan July 13, 2015 at 6:25 am

      Ps: found the solution: the snippet does not work with the non-American date format (dd/mm/yyyy). Although I thought you updated for that, so I am not sure if I am doing something wrong ;-) ?

      Regards,

      Johan

  71. Iliyas
    Iliyas July 1, 2015 at 1:31 am

    Hello David,

    The code works but showing jQuery error “Uncaught ReferenceError: jQuery is not defined” and makes my form very slow. Any solution for this issue? Error points to last line of script.

    Reply
    1. David Smith
      David Smith Staff July 1, 2015 at 8:08 am

      It sounds like this snippet does not support AJAX-enabled forms. Disabling AJAX should prevent this issue.

    2. A E
      A E July 1, 2015 at 8:18 am

      Yes, you are right. It was ajax but I want the AJAX to be true. So, can you please provide any solution?

    3. David Smith
      David Smith Staff July 3, 2015 at 12:24 am

      I have a perk in development that supports this for AJAX-enabled forms (and much, much more). If you’re interested in the GP Date Time Calculator perk, pick up a copy of Gravity Perks and drop me a line via support.

  72. Marcello
    Marcello June 17, 2015 at 7:49 am

    Hello,

    thanks for this helpful article!

    I have a question: I would like to limite the date range of the first picked to “today”, so I added the following line of code to my custom js:

    $(‘#myStartDate’).datepicker({ minDate:0});

    It disables the past dates, but it prevents the date calculation from working. Any idea?

    Thanks!

    Reply
    1. Marcello
      Marcello June 17, 2015 at 3:01 pm

      Hello David,

      thanks for answering my question in such a short time! I was going to post the solution myself, I saw somebody made you a similar question in a previous post and you suggested to take a look at https://gist.github.com/richardW8k/515454542d1111e8c12c.

      I have another question though. Probably it’s not strictly related to your code but maybe you can help me shed some light on my problem: I have some bits of jQuery in the page to create a price breakdown (taking the number of days and multiplying it by some other fields to show a total price to the user while she fills the form). It works, but if you try to submit the form and the page reloads with some error (for example missing mandatory fields), then my jQuery stops working. Any idea what it might be due to?

  73. Raymond
    Raymond June 10, 2015 at 10:36 am

    Hmmmmmm…. I can’t seem to make this work. I’ve got 2 date fields a result field (single line text – is this ok?)

    I’ve put the snippet into functions (i’ve done this with some other snippets of yours fine.)

    But the result field just defaults to 0. So something IS happening and populating the result field but not as expected.

    Odd!

    See: http://goo.gl/z2c2bu

    Reply
    1. Raymond
      Raymond June 10, 2015 at 12:59 pm

      Aha! I found the problem. This happens when I have set a default value in the date fields like: {date_dmy}

      Now that I’ve removed these default values it works nicely ;-)

      Small bug….

  74. Gerrit
    Gerrit June 1, 2015 at 3:42 pm

    Hello David,

    I tried to apply the functionality to calculate the days between 2 dates (https://gravitywiz.com/calculate-number-of-days-between-two-dates/)! Nearly everything seems to work fine, BUT looking at the PDF date (&data=1) the calculated days a multiplied 2 times, so the sum of the price at the end is nor correct. The first calculation is correct. 80€ is the price per day. 7 is the number of resulting days (for example) =560€ (this is still correct

    But then the 560€ are multiplied again with 7 (=3.920,00€)

    and at the end the 80€ (price per day) are added to 3920€ =4000€ (the real total sum should be 560€ (=7×80€)

    Screenshot with Pdf data and my commentaries in red: http://awesomescreenshot.com/04e4y3xn67

    Could you please have a look whats wrong. I dont know anymore what to do!

    Cheers, Gerrit

    Reply
    1. David Smith
      David Smith Staff June 4, 2015 at 6:42 pm

      What is the PDF data? This snippet does not interact with the total. If you’re using it in a calculation, it should still work just fine.

  75. Ben W.
    Ben W. May 18, 2015 at 2:00 pm

    Hi,

    Excellent snippet, I’m wanting to know if it is possible to block out particular dates.

    For example: I have an event package available that has two nights at a hotel included in the price, however, I’d like to set up a conditional logic question that asks if they want to stay additional nights. If they select “yes”, then I’d like to have the date picker show, but block out the days they are already staying, so their only option is to arrive before the pre-chosen date, or stay later.

    Reply
  76. Abdul
    Abdul May 3, 2015 at 6:24 pm

    Hi David, Great tutorial… i have one question we can use gravity forms add on for woocommerce, if user define return date while purchasing product and on that date gravity form field (datepicker) value add stock in woocommerce product inventory like any rental website?

    Best Regards

    Reply
    1. David Smith
      David Smith Staff May 3, 2015 at 9:32 pm

      Hi Abdul, I’m not familiar with any solutions that work with both GF and WooCommerce for this. I believe WooCommerce has their own scheduling product that might do the trick?

  77. Robert de Leeuw
    Robert de Leeuw May 1, 2015 at 5:38 pm

    Dear David,

    Really love this snippet. Got it working with calculating days just perfectly. While I am filling out the form the calculated field updates just fine. But when I submit the form, it does not save. When I go to the entries, the calculated field is empty. It seems to be since the latest gravity form update. Any suggestions how to safe the field? I cannot send it to another form either..

    Thanks! Robert

    Reply
    1. David Smith
      David Smith Staff May 2, 2015 at 7:37 pm

      Hey Robert, I’ll continue working with you in Gravity Perks support on this.

  78. Carlos Flores
    Carlos Flores April 29, 2015 at 10:10 pm

    Great snippet of code. Thank you.

    By any chance can the dates enter stay within the fields? For example im building a rental booking website. It would be awesome if the first time a user enters a date to rent a product when they go to another product page form the same date would appear.

    Reply
    1. David Smith
      David Smith Staff April 30, 2015 at 12:25 am

      Hi Carlos, this is possible with a bit of Javascript to save the entered date to a cookie and a little PHP (or JS) to repopulate that cookie into the field. I don’t have any ready code for this.

    2. Carlos Flores
      Carlos Flores May 1, 2015 at 12:29 am

      I found a great little code to copy and prepopulate fields. In case someone else is looking for the same functionality.

      It will auto populate any field that is marked as “Allow field to be populated dynamically” with it’s previous value from a cookie.

      Add this to your functions.php add it before the calculate between dates code above

      http://pastie.org/10123477

    3. David Smith
      David Smith Staff May 1, 2015 at 7:58 am

      Awesome! Thanks for sharing, Carlos! I moved the code to a pastie for legibility. :)

  79. Robert de Leeuw
    Robert de Leeuw April 29, 2015 at 2:10 pm

    Hi there David,

    Love this snippet, I even got your beta Perk to work with. A life saver, thank you so much.

    But I have a new challenge. I need to calculate a date back in time and then count the days between now and then. To be precise: field_1 = a date in the future (user can set this date themselves) calculated_field_1 = field_1 – 280 days calculated_field_2 = days between calculated_field_1 and today The result in calculated_field_2 is a pregnancy duration in days (field_1 is estimated due date).

    So tried to use something like this: {due date:2:age} – 280 for calculated_field_1, but this does not work. It seems that :age goes to -1 minimum.

    Help would be much, much appreciated.

    Thanks! Robert the Netherlands

    Reply
    1. David Smith
      David Smith Staff April 29, 2015 at 7:22 pm

      Hi Robert, this should be possible with the GP Date Time Calculator. Can you ping us via the support form with these same details? We can help you work through the logic.

  80. Johan Verhagen
    Johan Verhagen April 6, 2015 at 8:52 am

    Hey David,

    First of all my compliments for the snippet; very useful!

    Unfortunately, when I copied it in my functions.php, I got a warning that my plugin was deactivated, as I had created a fatal error:

    Parse error: syntax error, unexpected ‘<‘ in /home/mhid1163/public_html/ghanaticketservice.com/wp2/wp-content/plugins/gravityforms/gravityforms.php on line 3156

    Any way to solve this?

    Thanks in advance!

    Best regards,

    Johan

    Reply
    1. Johan Verhagen
      Johan Verhagen April 6, 2015 at 9:04 am

      Dear David,

      My apologies; I did not follow the extra instructions down below the response form, and just had to remove the <?php.

      Thanks a lot; it works great!

      Best regards,

      Johan Verhagen

    2. Johan Verhagen
      Johan Verhagen April 6, 2015 at 9:40 am

      Hey David,

      First of all: thanks for your amazingly quick reply; highly appreciated!

      Last question (hopefully); I got the snippet working, for as far as it calculates the days indeed. But somehow, linking it to the product prize and the ‘total’, does not work.

      Is this because I do not have the Gravity Perk license and is it in ‘read only’ mode now, or am I doing something wrong?

      Thank you,

      Johan

    3. David Smith
      David Smith Staff April 6, 2015 at 9:43 am

      Hi Johan, you’d need to use the merge tag for this field in the formula of a Calculated Product field. When the number of days is updated, the formula will be recalculated and the total will be affected accordingly. :)

    4. Johan Verhagen
      Johan Verhagen April 6, 2015 at 10:28 am

      Hey David,

      Of course… Haha! It worked, thanks a lot =) .

      Just wondering how you hide this calculated product on your site? It does work, but it works a bit as a double ‘total’ now: both the calculated product as the ‘total’ are showing the same.

    5. David Smith
      David Smith Staff April 6, 2015 at 10:31 am

      If you’re using the latest version of Gravity Forms, you can hide it by adding the “gf_invisible” class to your calculated product field.

  81. Eleni
    Eleni March 9, 2015 at 8:32 pm

    Hi David,

    Is there any way I can limit the user to selecting dates that span a max period of 90 days for example?

    Reply
    1. David Smith
      David Smith Staff March 9, 2015 at 10:36 pm

      Hi Eleni, you can do so by

      1 – Adding a new HTML field to your form. 2 – Copy and paste this code into the content setting of this HTML field: http://pastie.org/9714044

      You’ll want to update the “+2 W” to “+90 d” (2 weeks vs 90 days).

    1. David Smith
      David Smith Staff February 18, 2015 at 11:06 am

      Hi Jay, this is possible with the upcoming GP Date Time Calculator plugin (available now by request to Gravity Perks license holders). You just install the plugin, add a Number field, enable calculations, specify your Date field merge tag and at the “:age” modifier.

      {Date:12:age}

    2. jayaram
      jayaram February 18, 2015 at 11:42 am

      David,

      Thanks! I have managed to use jQuery for now to get the age from the dob date picker and made it readonly so that the user cannot edit the age.

  82. Brian
    Brian February 11, 2015 at 6:26 pm

    This snippet was working great until I updated to the latest version of Gravity Forms yesterday. Has something changed? Thanks!

    Reply
    1. David Smith
      David Smith Staff February 11, 2015 at 6:55 pm

      Hi Brian, try getting the even-more-latest version of Gravity Forms from the downloads page and also re-copy-and-pasting this snippet over the previous version. There have been updates to both since yesterday.

    2. Brian
      Brian February 11, 2015 at 7:14 pm

      Hi David, I updated to that version, updated the code to the above and it’s still not calculating. Any ideas? As always, thanks for your help!

    3. Brian
      Brian February 11, 2015 at 11:26 pm

      Thanks David. I gave that a try and it still didn’t work. I’m sure it’s something on my end. I ended up reverting to the previous version of Gravity Forms and it is working again. I’ll give it another go around on the next update. Thank you!

  83. James
    James February 10, 2015 at 3:29 am

    Hi, Nice work. I have just one issue with the sniet, why does it give weird calculation results if you have the dates in non US format?

    Thanks

    Reply
  84. PrSetiadi
    PrSetiadi February 9, 2015 at 6:02 am

    Hi, How to implement the snippet on multiple forms — especially on the same page? Could you please guide as I’m no expert in php. Thanks.

    Reply
  85. PrSetiadi
    PrSetiadi February 9, 2015 at 2:50 am

    Hi David, This is maybe a stupid question, but I had to ask one thing — as I’m not expert in php — about the new ‘instance’ you’ve stated above.

    If you would like to have this functionality on multiple forms then just create a new instance of the class and fill in the parameters for the new form.

    So, if I need to have it on another form, do I need to copy-paste the whole code with a new parameter or just create a new set of parameter? new GWDayCount( array( 'form_id' => 1, 'start_field_id' => 1, 'end_field_id' => 2, 'count_field_id' => 3, 'include_end_date' => false ) ); and then create another below it with this? new GWDayCount( array( 'form_id' => 2, 'start_field_id' => 1, 'end_field_id' => 2, 'count_field_id' => 3, 'include_end_date' => false ) );

    Would you please help? Thank you in advance. Regards, prSetiadi

    Reply
    1. David Smith
      David Smith Staff February 9, 2015 at 11:46 am

      You’ve got it right. Just create a new copy of the new GWDayCount( array( … ) ) bit like you’ve demonstrated. :)

    1. David Smith
      David Smith Staff January 28, 2015 at 9:08 am

      Hi Arven, to exclude weekends you’ll want to pickup a copy of Gravity Perks for access to the GP Date Time Calculator perk. This plugin is really powerful. It uses the GF Calculation field so you don’t have to touch any code. It offers a special merge tag for calculating both weekdays and weekends. Here is the weekday merge tag:

      Simplified {weekdays:{startDate},{endDate}}
      Actual Example{weekdays:{Check-in:5},{Check-out:6}}

      The GP Date Time Calculator perk has not been officially released yet but it is available by request for Gravity Perks license holders.

    2. Adam
      Adam February 19, 2015 at 6:32 am

      Hello David,

      I need a good solution for a rental-service, which offers different products for rent. Is it possible with the help of “GP Date Time Calculator perk” to calculate different prices for weekdays and weekends?

      Example: Weekend-special: Renting from Friday to Monday results in discounted price Regular: Renting between Monday and Thursday -> fixed price per day

    3. David Smith
      David Smith Staff February 19, 2015 at 7:10 am

      It sure is! To calculate the number of weekend days between two dates, you would just add Calculation field to your form and use the following merge tags: {weekendDays:{Start Date:1},{End Date:2}}. So basically {weekendDays:DATERANGE}. You would then take the number of days and multiply it by your different rates.

      Here’s an example based on reserving a room at a hotel:

      ( ( {weekdays:{Check-in:5},{Check-out:6}} ) * 150 ) + ( ( {weekendDays:{Check-in:5},{Check-out:6}} ) * 250 )

      We first get the number of week days and multiply that by $150 (our weekday rate) and then we get the number of weekend days in the same date range and multiply that by $250 (our weekend rate).

    4. Adam Maj
      Adam Maj March 9, 2015 at 9:45 am

      Hey David,

      I bought Gravity Perks and tried to put GP Date Time Calculator perk into use. I tried using your example-snippet to start out, but it doesn’t seem to work right. It doesn’t matter what date-range is picked, the price always goes to 150.

      See here: http://tischemieten.de/test/

      Thanks in advance

  86. carrie
    carrie January 20, 2015 at 1:26 pm

    Hi,

    Great Addon, but may I know how can I add the day(s) word on the date after, like below :

    E.G. 12 days <– output result

    Thanks a lot (=

    Reply
    1. David Smith
      David Smith Staff August 4, 2015 at 7:41 pm

      Hi Carrie, your comment was lost. I’m sorry about that. I don’t currently have a solution for this.

  87. Adam
    Adam January 9, 2015 at 1:20 am

    I have identical issue as

    “I have setup the date inputs with format dd/mm/yyyy. This causes the following problem: when I set a starting date at Oct. 1 2014 (the preview date for some reason it converts to 10/01/2014 instead of 01/10/2014 ) and end date Oct. 2 2014 (same here preview date converts to 10/02/2014 instead of 02/10/2014) the count result is 32 (it counts the days from Jan 10 2014 to Feb 10 2014).”

    Reply
    1. David Smith
      David Smith Staff February 9, 2015 at 8:21 pm

      Hi Adam, I sent you an email requesting a form export. Looking forward to getting this sorted. :)

    2. adam
      adam February 9, 2015 at 9:17 pm

      Thanks,

      I had replied but perhaps spam filter caught it. Although I sent a full export of the form that time.

      I just sent an export of a basic form with 2 dates and the count field where the issue is replicated.

  88. Ryan
    Ryan December 21, 2014 at 10:13 pm

    Hi David,

    The company I work for is looking to calculate the amount of time between two time fields. I saw you mentioned above that you have a snippit in the works that might solve this issue and that it’s currently in beta. Any progress on that? We’d be happy to test it and to pay for a solution.

    Thanks! Ryan

    Reply
  89. Reece Cropley
    Reece Cropley December 8, 2014 at 5:20 am

    Hello I commented last week about getting this code to work using a UK time format, the same issue as Stelios on October 18, 2014 at 1:05 pm.

    I am guessing that these comments are moderated before they come up on the site. I was wondering if you had seen it.

    If for some reason it didn’t go through. The issue was to get the code snippet working with a UK format. Is there a solution. if you would like to email me directly then please feel free, or if you would like to me email to you directly then what is the email address to use?

    Thank you

    Reece Cropley

    Reply
  90. Reece Cropley
    Reece Cropley December 4, 2014 at 8:29 am

    Hello, Thanks for some great code.

    I am experiencing the same issue as a few other comments. Its the date format. I am using this for a UK based website and I will need to the date format in DD/MM/YYYY.

    When the form date fields are set to the UK format the calculations do not work. Was there a version of this code that included the other date format?

    Thanks in advance

    Reece

    Reply
  91. Adam
    Adam November 27, 2014 at 5:46 pm

    Hi David,

    I have the same situation as previous comment;

    Hi and thanks for the code. I have the same problem as Marieke. I have setup the date inputs with format dd/mm/yyyy. This causes the following problem: when I set a starting date at Oct. 1 2014 (the preview date for some reason it converts to 10/01/2014 instead of 01/10/2014 ) and end date Oct. 2 2014 (same here preview date converts to 10/02/2014 instead of 02/10/2014) the count result is 32 (it counts the days from Jan 10 2014 to Feb 10 2014).
    Reply
  92. Adam
    Adam November 24, 2014 at 7:03 pm

    Awesome add-on!

    Can we get this to work on multiple areas of one form; eg: moved in date, today’s date = days at current address moved in date, moved out date = days at previous address

    Thanks in advance

    Reply
  93. Jennifer
    Jennifer November 23, 2014 at 10:16 pm

    I tried to purchase the Perks and each time I enter payment info, I get a page that says my cart is empty. I am trying to buy the Perks so I can use this snippet. Please help.

    Reply
  94. Darren
    Darren November 19, 2014 at 10:04 am

    Thanks for sharing this fantastic snippet, it’s incredibly useful.

    I was wondering if there was a simple way of excluding Saturday and Sunday from the total number of days? I need to total the amount of working days (mon-fri) in a date range.

    Many thanks :)

    Reply
  95. Robert de Leeuw
    Robert de Leeuw November 17, 2014 at 5:18 am

    Dear David,

    Great snippet! Thanks a lot. Love to use it with the read-only Gravity Perk field. But do you think I can also use it to calculate years? It would be great to have a user set their birthday, and then have a field with the age in years.

    Thanks for your help! Kind regards, Robert the Netherlands

    Reply
    1. David Smith
      David Smith Staff November 17, 2014 at 9:53 am

      Hi Robert, responded to your email. This is possible with the upcoming GP Date Time Calculator perk. It’s still in beta but is available by request for any Gravity Perks users.

  96. Stelios
    Stelios October 18, 2014 at 1:05 pm

    Hi and thanks for the code. I have the same problem as Marieke. I have setup the date inputs with format dd/mm/yyyy. This causes the following problem: when I set a starting date at Oct. 1 2014 (the preview date for some reason it converts to 10/01/2014 instead of 01/10/2014 ) and end date Oct. 2 2014 (same here preview date converts to 10/02/2014 instead of 02/10/2014) the count result is 32 (it counts the days from Jan 10 2014 to Feb 10 2014). You can see an example here: http://www.misthodosia.eu/test/ I am using Gravity Forms 1.8.17 Is there a way to fix the format problem? Thanks!

    Reply
  97. Marieke
    Marieke October 15, 2014 at 1:08 pm

    Hi,

    First of all, love this code, we have been using for a while now on a clients website, but after the Wrdpress update it’s working properly. I have changed the code into the above version, but it gets the dates wrong, the start_field_id and end_field_id have changed into a different format. In Europe we use d/m/y but as soon as I change the code, the format becomes m/d/y, I have looked over both the old and the new code, but I can’t seem to figure out why it is changing, the code looks almost the same.

    Do I have to change the date-format in the code to d/m/y?

    Reply
    1. David Smith
      David Smith Staff October 14, 2014 at 6:16 pm

      Hi Will, this will calculate them together. Do you mean you want to separate counts for weekdays and weekends between two dates?

    2. Will
      Will October 16, 2014 at 10:28 am

      Thanks for the quick reply! Yeah, I’m curious how to separate counts for weekdays and weekends. I think just about every reservation for hotel or B and B that I’ve worked on always has different pricing structures for weekdays and weekends. Some even include Friday in their weekend pricing.

      Thanks!

    3. David Smith
      David Smith Staff October 17, 2014 at 1:07 am

      I have a perk coming soon that will allow you to do this. It’s called GP Date Time Calculator and it will take the functionality covered in this snippet and give it a heavy dose of cocaine. It will also allow you to calculate the number of weekdays and/or weekend days between two dates.

      If you’re interested, pick up a copy of Gravity Perks and drop me a line on support to get early access to this new perk.

  98. Ron Sanders
    Ron Sanders October 5, 2014 at 4:46 pm

    David,

    I know we just communicated regarding some of the address and geo-mapping scripts. I’m working with a developer to design either modifications we discussed or another plugin. Hopefully will be done in a couple of weeks.

    But I have another need, and was hoping you might be able to guide me. I need a “Time Calculation” – Basically, when a user selects a time on our forms, I need a field to subtract about 90 minutes, plus a time (usually in minutes) that will be sent back from our Mapping script, and copy the new value into another “Time Field”.

    To make this more clear, a customer or our dispatcher will select a time for Airline Flight Departure. From that time, we will subtract 90 minutes (Airlines recommended time for arrival before flight departure), and subtract another specified amount of time for travel on the distance (based on the time to travel route returned by the Geo/Google Maps Script we are working with), i.e.: 20 minutes. This will then put on the form the “Recommended” pick-up time for the reservation.

    It seems that some of the basic code is already there from the “Calculate Dates” script/perk we are using. What I’m trying to figure out, is how to modify or add those calculation functions into a hidden calculated field for time.

    Thanks for any guidance. Or if I need to, I’ll see if my coder can add this to my other stuff.

    Thanks,

    Ron

    Reply
    1. David Smith
      David Smith Staff October 7, 2014 at 11:57 pm

      Hi Ron,

      Can you drop me a line via the Support Form. I’ve got a new perk in the works that should be able to handle this with ease. I’d love to get the early beta in your hands for some testing. :)

    1. David Smith
      David Smith Staff September 17, 2014 at 1:28 am

      Hi Tom, I’m not sure I understand your issue. I took a look at the form but it doesn’t appear that the snippet has been configured for this form yet?

    2. Tom Boersma
      Tom Boersma September 17, 2014 at 1:35 am

      Yes I configured it like this. And at least something is happening since the number of days shows after refreshing the page…

      new GWDayCount( array( ‘form_id’ => 9, ‘start_field_id’ => 9, ‘end_field_id’ => 10, ‘count_field_id’ => 13 ) );

  99. Ratna
    Ratna September 12, 2014 at 7:07 pm

    Hey David,

    Thank you for sharing the script, it was a life saver. Perhaps you can save me one more time :-). I am trying to take to fields with Postcode and Address, and find the distance between them, depending on this distance a delivery fee is calculated. I tried to emulate using the example of the dates, but had no luck. Any guidance you can offer? Once again thank you for sharing this script and glad to have found your website.

    Have a lovely weekend.

    Cheers Ratna

    Reply
    1. David Smith
      David Smith Staff September 15, 2014 at 10:06 pm

      Hi, Ratna. Your question is a little open ended. You’ll probably be better off hiring a developer to assist you with this one.

    2. Ron Sanders
      Ron Sanders September 15, 2014 at 10:32 pm

      Ratna,

      I may have your solution. I paid for a developer to program a script, which takes two address fields data from Gravity Form #1, sends it to Google Maps, and calculates the mileage, then passes that data back to Gravity Form #2 in Step two, including mileage, and addresses to complete a customer reservation for local airport shuttle company. We base the rate on the mileage returned, and also use the Map data to pass on to the drivers.

      If you are interested, I would be willing to share what I have for a fraction of original investment I paid the developer.

      Contact me via email ron@sfiremedia.com

  100. sunil
    sunil September 12, 2014 at 1:01 pm

    Hi David, We are using your code snippet and it is very useful to us. Based on this script, we are trying to calculate the distance between two post codes,Based on the distance, we have to display the price on the third input field. The price need to be added to the total automatically. We are using google maps to find the distance between the post codes. Can you please suggest how can we do it. Any help is appreciated.

    Reply
  101. denis
    denis August 26, 2014 at 7:31 am

    Hi, I have a form for a sort og booking quotation. The form uses two step (I’m still developing it) and in the 2nd step, when I choose the second date (“Data di partenza da Friburgo”) I get the error TypeError: format is undefined format = format.split(‘_’); Line 233

    Could you help me? The plugin works also in multple-steps form?

    thank you, Denis

    Reply
  102. Jane
    Jane August 21, 2014 at 2:09 pm

    Your instructions are grey. Even a newbie like myself has been able to make this work. My question is, is this possible in Gravity Forms?

    Calendar function: Entry date ==> selected by customer ==> April 15, 2015 Number of days (nights) ==> selected by customer in drop down field ==> let’s say 3 Automatically show the exit date of ==>April 18, 2015

    Reply
    1. David Smith
      David Smith Staff August 21, 2014 at 9:26 pm

      Hi Jane, this isn’t currently possible (without additional custom code) but I’m working on an awesome new perk that will handle this beautifully. I’ll notify you as soon as it’s ready. :)

  103. Letty
    Letty August 18, 2014 at 3:20 pm

    I am also looking at let’s say holiday season pricing calculations and am wondering if this is even remotely possible.

    If the start date =< than December 13, 2014, and end date is = >January 5, 2015 add 10% to a hidden field that can be used later in the calculations.

    Normal Daily Rate = $500.00 Inquiry is for December 15 to December 19 (nights = 4) $500 x 4 X 1.1=$2,200

    Just wondering if this is possible.

    Reply
  104. Amber
    Amber August 6, 2014 at 3:36 pm

    Hi David,

    I couldn’t find a “Contact” form to submit this request through but is it possible to modify this snippet to calculate numbers between gravity forms “Time” fields; like an employee timeclock?

    Reply
    1. David Smith
      David Smith Staff August 6, 2014 at 6:33 pm

      This snippet won’t do that for you out of the box but if you’re interested in commissioning the customization, I’d love to add support for it. Get in touch!

  105. Egbert
    Egbert July 21, 2014 at 8:55 am

    Hi David, Thanks for the code snippet, its very usefull! I was wondering, what do i need to instead of showing the number of days, use the numer of days in a different place of my script. Im not that familiar with JS/Jquery and i cant seem to wrap my head around it.

    Egbert

    Reply
  106. David
    David July 7, 2014 at 5:14 pm

    Hi David– Great snippet. I’m curious how feasible it would be to calculate the number of days between today and a date in the past in order to calculate a late fee. Essentially $1 a day past May 20. I think this snippet is pretty close to what we are looking for, but we would need to get this into a product calculation to add to the order total. Thanks for your insight.

    Reply
  107. preeti
    preeti June 19, 2014 at 6:42 am

    I pasted the code at the bottom of my theme functions.php and included the following lines below the code but it isn’t working and am not sure what the problem might be:

    new GWDayCount( array( ‘form_id’ => 1, ‘start_field_id’ => 6, ‘end_field_id’ => 7, ‘count_field_id’ => 26, ‘include_end_date’ => false ) );

    Please help me asap.

    Reply
  108. Dayo
    Dayo June 10, 2014 at 8:39 am

    I pasted the code at the bottom of my theme functions.php and included the following lines below the code but it isn’t working and am not sure what the problem might be:

    new GWDayCount(array(1,6,7,26,false));

    new GWDayCount(array(1,21,22,27,true));

    Please help. The first is to calculate number of nights for accommodation while the second is to calculate number of days for car rental. ‘

    URL is http://makeitnigeria.com/submit-booking/

    Reply
    1. David Smith
      David Smith Staff June 14, 2014 at 8:29 am

      Hi Dayo, you need to include the “keys” for each of the values in the parameters passed to the GWDayCount class. Currently, you just have the values. If you look at the usage example, you’ll see that the keys should be preserved (i.e. ‘form_id’, ‘start_field_id’, etc).

  109. Bas
    Bas April 30, 2014 at 3:30 pm

    Hi, Am i correct in concluding that this does not work if you set the visiblity of one of the fields to Admin Only? I want to enable some fields based the results, but I dont want the user to see the enddate and resultfield. How can i accomplish that?

    gr Bas

    Reply
    1. David Smith
      David Smith Staff April 30, 2014 at 3:42 pm

      Hi Bas, you are correct. Admin Only fields do not actually get output to the page and are pretty much ignored by Gravity Forms until submission. You’ll want to hide the field via CSS by setting the “CSS Class” setting to “gf_hidden”. It’s a built in class for hiding Gravity Form fields.

  110. Ron
    Ron March 10, 2014 at 1:37 pm

    David,

    Your date calculation has been amazing!!! With some recent updates though, a conditional logic html field that was “hidden” before based on the “default value” of my ‘count_field_id’ (Days in Advance) is no longer pre-populating that field with my outrageous number. To explain more: I have the count_field_id, advanced field, “default value” set to ‘99999’. Then in the html field I want to show/hide, I have conditional logic enabled for “all” – 1)Show if Days in Advance – Is Less Than – ‘2’ & 2) Show if Days in Advance – Is Not – ‘99999’. The “Days in Advance” field is hidden with gf_hidden. But I’ve checked and when the form loads it’s not pre-populating with the ‘99999’. I’m not sure where it’s bogging down, but think it may be in the GWDayCount script. Any ideas?

    Reply
    1. David Smith
      David Smith Staff March 10, 2014 at 5:13 pm

      Hey Ron, could you send me a copy of your functions.php file and an export of your form? Alternately, if you’d like to just send me a WP login for this site, you know my gravitywiz.com email. :)

  111. Sergi
    Sergi March 10, 2014 at 12:15 pm

    Hi, David,

    I need calculate time in hous a minuts, into two times ( time start and time end) and the result publih in input in gravity,

    what is the code?

    Reply
    1. David Smith
      David Smith Staff March 10, 2014 at 5:15 pm

      Hi Sergi, you can update this line (199):

      $day_count = $diff / ( 60 * 60 * 24 ); // secs * mins * hours

      to:

      $day_count = $diff / ( 60 * 60 ); // secs * mins

      …to convert the day count to minute count.

  112. Wendy
    Wendy March 5, 2014 at 10:29 pm

    I’m looking for a way to have my form allow for a dropdown number based upon what month of the year it is. In July, it would allow a choice between 1-10, and each following month would allow one less option: August, 1-9; September 1-8, October, 1-7), etc. Ideally, once the coding is set, it should work year after year. Do you think your snippet could help to accomplish this goal?

    Reply
    1. David Smith
      David Smith Staff March 6, 2014 at 9:18 am

      Hi Wendy, this particularly snippet probably won’t help much; however, the Use Gravity Forms Conditional Logic with Dates article will get you much closer. It’d would still be a bit of manual work as you would need to set the start and end range for each month for each condition and then you would need to update that at the beginning of each year with new timestamps for the month ranges.

      I’d love to add support for this to my Conditional Logic Dates perk. It is a planned feature but I’d be happy to prioritize it if you’d like to commission the feature.

  113. Adrian Jefferies
    Adrian Jefferies February 26, 2014 at 6:29 am

    Great snippet – thanks. I needed to show years rather than days (to calculate a person’s age after they input their date of birth), so I aded this line: dayCount = Math.floor( dayCount / 365.2425); after this one: dayCount = Math.round( dayCount ) + this.options.countAdjust;

    365.2425 is the real number of days in a year. This may be useful to others with the same scenario.

    Reply
  114. OLA
    OLA January 21, 2014 at 8:57 am

    Thank you for this post is indeed a life saver. However, i want to use this for an travel insurance product where price will be based on the duration of the time that will be spent for the trip and additional price for other individuals or family members based on their date of birth

    Reply
    1. David Smith
      David Smith Staff January 22, 2014 at 11:59 pm

      Hi OLA, I’d need more information on what you’re trying to accomplish and where this current solution is falling short to better advise on alternative solutions.

    1. David Smith
      David Smith Staff December 23, 2013 at 7:14 am

      Hi Prashant, this blog is for Gravity Forms, a WordPress plugin which runs on PHP. I’m not familiar with Java. Best of luck finding a Java version. :)

  115. Rens
    Rens December 17, 2013 at 3:31 am

    Hello David,

    Thanks for you fast reply and the offer.

    I read some things about php code and code it myself yesterday. If there isn’t an week selected the code will return -1. After that you can make a error code on that -1. After I found the sollution it was quite easy to implement.

    The only thing thats left is the same problem as Sebas, different prices for different periods. For example the holidays are per week more expensieve than normal weeks.

    Thanks again.

    Reply
  116. Rens
    Rens December 16, 2013 at 11:05 am

    Hello David,

    Nice Snippit! Works fine!

    I use this snippet for pricing a rental home.

    But some days are more expensieve than others. So is basically have the same question as Sabas?

    Also i would like to add a functions that gives an error when the number of days are not correct. You can rent the place only for 7, 14, 21 etc days. Is there a way you can integrate this into this snippit?

    Do you have a sollution for both problems?

    Thanks in advance!

    Reply
    1. David Smith
      David Smith Staff December 16, 2013 at 6:27 pm

      Hi Rens, I’d love to add support for counting only week days and only weekends. Are you interested in sponsoring this enhancement? I’d estimate about an hour of effort. My hourly rate is $100. Contact me here if you’re interested.

    2. Rens
      Rens December 17, 2013 at 3:31 am

      Hello David,

      Thanks for you fast reply and the offer.

      I read some things about php code and code it myself yesterday. If there isn’t an week selected the code will return -1. After that you can make a error code on that -1. After I found the sollution it was quite easy to implement.

      The only thing thats left is the same problem as Sebas, different prices for different periods. For example the holidays are per week more expensieve than normal weeks.

      Thanks again.

  117. xmen
    xmen December 5, 2013 at 2:18 am

    Hi there. I need your help.

    Price calculation have some problem. below: product:Field ID 10.see how the form currently works. ( {Insurance:9} * {Number of Days:3} + {Battery Option (Extra Battery):8.2} * {Number of Days:3} + {Battery Option (Portable Charger):8.1} * {Number of Days:3} + {Select Single Country:7} * {Number of Days:3} ) –> it means (Mobil WiFi + Battery Option + Insurance) x Days Rental = Rental Price

    this is work but Total Price Number(total in cart woocommerce) is wrong. Can I remove total price in cart? or some any tip?

    please help. Thank you.

    Reply
    1. David Smith
      David Smith Staff December 5, 2013 at 1:40 pm

      Does this work when not used in combination with WooCommerce? Do you have a URL where I could see this in action?

  118. Sebas
    Sebas December 3, 2013 at 9:41 am

    Hi Dan,

    I use this snippet for pricing for a car rental website. But is there a way to price by day and weekends? ‘Cause if you rent a car in the weekends it is cheaper. And if you rent a car for 7 days it is cheaper also. Example: 1 day costs 29 euro, but 7 days will cost 174 euro. A weekend costs 49 euro.

    Thanks in advance!

    Reply
    1. Jun
      Jun December 2, 2013 at 4:16 pm

      Yes! And I did it. I like this gravity form! This is so nice. Thank you for your help! And I’ll try another one ;)

    1. David Smith
      David Smith Staff November 22, 2013 at 1:41 pm

      Hi Vino, you do not need to purchase anything else. Just follow the instructions and you’ll be good to go. :)

    2. Vino
      Vino December 4, 2013 at 4:15 am

      Thanks David, now it’s working fine. Another one help i’m trying “Arrival date and return date”.

      with the calendar it is possible to select a arrival date on 02/12/2013 for example and a return date on 01/02/2013 which is a problem because people may make a mistake.

      Please advise.

  119. Ken
    Ken November 14, 2013 at 6:05 pm

    How about doing this with time having either a start and stop time as a drop down and then a read-only field that calculates the time difference?

    Reply
    1. David Smith
      David Smith Staff November 14, 2013 at 7:13 pm

      Hi Ken, it actually might work if the dates in the drop down’s option values are in the same format as the datepicker field would be. For read only functionality check out Gravity Perks GP Read Only perk.

  120. Dan Baritchi
    Dan Baritchi November 3, 2013 at 2:37 pm

    Hey David! Love Gravity Forms and this is an awesome addition! Is it possible to use this method to calculate the date that is “14 days from today”? For example – someone signs up for a free trial via your Gravity Form – and on the confirmation page and in the conformation email you want to show them the date on which they’ll be billed – which is “today + 14 days” Thanks!! :-)

    Reply
    1. David Smith
      David Smith Staff November 4, 2013 at 8:10 am

      Hey Dan, this is definitely a good idea. This snippet has the foundation for such a calculation but it would need to be customized a bit to actually work per your requirements. Keep bringing this up and I will tackle it one of these days.

  121. Ryan Dolan
    Ryan Dolan October 10, 2013 at 4:06 pm

    Hi, What would I need to do in order to check if person is 18 or older? For a form I am building, I want a parent waiver to be required if not 18 years old.

    Reply
  122. Aira
    Aira October 8, 2013 at 11:05 am

    Hello, thanks for your tutorial, But I have a problem , how to calculate between two dates basiccaly of 24 hours? for example if start date on 01 jan 13 and end date 02 jan the result is 1 not 2. Thanks for your attention

    Reply
    1. David Smith
      David Smith Staff October 8, 2013 at 7:24 pm

      Hi Aira, sounds like you just need to set the "include_end_date" to false when you initialize the GWDayCount class. Take a look at the Count “Nights” Only example above.

  123. pete
    pete August 15, 2013 at 4:27 pm

    Thank you very much for this plugin! There is only one issue.

    I am using a form with conditional logic (a Gravity Forms’ form of course). Moreover I call in inside my template with gravity_form(..).

    In HTML source code the form is placed inside a div with the following attributes

    <

    div class=’gf_browser_gecko gform_wrapper’ id=’gform_wrapper_4′ style=’display:none’>.

    I already know that all conditional logic forms are styled with “display:none” which gets removed by your JS (if there is no error). But there is an error.

    I wanted to be sure before posting this and went through my plugins many times, deactivated all and tested each separatly.

    So, all in all it seems as your above plugin causes the JS error “Uncaught ReferenceError: jQuery is not defined”.

    Without conditional logic in a form your plugin works like charm!

    Best, Pete

    Reply
    1. pete
      pete August 15, 2013 at 4:45 pm

      I have to add that the JS error “Uncaught ReferenceError: jQuery is not defined” also occurs without the above plugin only with Gravity Forms (checked all other plugins and the theme I am using; deactivated all and tried TwentyEleven)+ multi-page-form + conditional logic + gravity_form(..) in template.

      But I managed that with “gform_init_scripts_footer”. Activating your plugin again the error re-occurs. Chasing the problem I tested my thesis many times.

    2. pete
      pete August 16, 2013 at 6:39 am

      I want to tell you that I could solve the issue.

      The problem was that I moved all GF scripts to the footer (by gform_init_scripts_footer).

      So your plugin’s JS was still line before jQuery was loaded.

      In your plugin I set

      Now everything works properly. Sorry for inconvience but maybe others will face the problem as well.

      Best, Pete

    3. pete
      pete August 16, 2013 at 6:43 am

      Oh my gosh, sorry again. The script and php tags were removed by comments section.

      I put your plugin’s JS in a php function like this:

      function script_to_footer { ‘opening tag JS’ [your JS] ‘closing tag JS’ ‘php’ add_action(‘wp_footer’,’script_to_footer’,100)’php’

  124. Michael
    Michael July 18, 2013 at 8:12 am

    I’m kinda new to this but I reckon this can also be integrated into woocommerce as well? I already got the extension for gravity forms for woocommerce but I’ve been looking for a way to sell my car rental service using the datepicker to calculate the booking by using both plugins (gravity forms + Woocommerce).

    Any help would be awesome!

    Reply
  125. Jack
    Jack June 18, 2013 at 7:04 am

    David, You sir are a gentleman & a scholar.

    Question, How hard would it be to do prices based on amounts of days?

    For example Minimum of 7 days = $50 per week. Each additional day is $8 until the second week etc.

    Reply
  126. Nicholas
    Nicholas June 14, 2013 at 11:35 am

    Love this site and GF 1.7.5! but… I’m getting an Uncaught ReferenceError: jQuery is not defined. from line 127. Our site includes jQuery 1.8.3 in the . Ultimately trying to modify this snippet to calculate total hours from 24 time pickers. Also looking for an easy way to default to PM instead of AM for evening time pickers.

    Reply
  127. Kavya
    Kavya May 31, 2013 at 8:04 am

    hi .. i am new to development..i need a help. i want to calculate the number of leaves taken by employee between two dates along with am and pm. suppose the dates is like 31-05-2013 am to 31-05-2013 pm the leave should show as 1 day .how can i consider am & pm while calculating the leave. kindly help

    Reply
  128. Scott
    Scott May 23, 2013 at 2:50 pm

    Hello-

    this is what I am looking for but can’t get it to work (i’m sure I am missing something simple in my setup). nothing ever populates ‘the count_field_id’

    what I need to do is calculate the date picked/entered in – against the current date + 3o days. if the dated picked is greater (more than 30 days out) then show the rest of the form.

    basically its a date check to make sure they are picking a date at least 30 days in the future.

    any help would is greatly appreciated.

    thanks-

    Reply
    1. David Smith
      David Smith Staff April 29, 2013 at 7:22 pm

      Hi Zlaja, it was developed on 1.6.11. You can upgrade to the latest Gravity Forms for only $39. Gravity Forms 1.7 is amazing. :)

  129. Jennifer
    Jennifer April 18, 2013 at 2:24 pm

    Would love to know how to add a specified number of days to a date field. e.g. today +14 days… We would use this as follows: “You will not be billed until the end of your 14-day free trial, your credit card will be billed $12.00 on “x” date”

    Reply
  130. Jarryd C.
    Jarryd C. April 8, 2013 at 3:23 am

    Would it be possible to add in support for the “Product” field type’s Quantity field? The ID differs from the parent field type’s ID.

    I’ve managed to do it manually by changing the jQuery selector to “#ginput_quantity_” rather than “#input_”.

    Bloody awesome snippet by the way! :D

    Reply
  131. andrew
    andrew April 6, 2013 at 6:09 pm

    Hiya – any possibility for it to support a working week calender – ie does not include weekends? in the calculation ..

    Reply
  132. Tony Fischesser
    Tony Fischesser March 25, 2013 at 1:08 pm

    David, I am “really” new to Gravity Forms. Your snippet looks like what I need. I have a form, that I pass “arrival date” from the previous web page. The user then enters the “Departure date”. I need to know the # of Nights they will be with us. 1. You state it only works with Date Picker fields. Will it work ok if I define my field as date picker, but auto populate it? 2.instantiated – I don’t quite understand this. Do I add GWDayCount() to the end of the Functions.php? 3. Where do I “Call” this function?

    Thanks.. I am surprised that this is not a standard function in Gravity forms.

    Reply
  133. Brian
    Brian March 14, 2013 at 10:45 pm

    This is absolutely incredible! Thank you. One thing I do notice is that it breaks the form if you use any type of conditional logic. The form doesn’t show. Any ideas on why this happens?

    Reply
    1. David Smith
      David Smith Staff March 15, 2013 at 10:51 am

      Hi Brian, thanks for letting me know. I’ve updated the snippet to support forms with conditional logic.

    2. Brian
      Brian March 15, 2013 at 11:24 pm

      Thank you David. The updated snippet did the trick! I’ve sent you a donation. You are much appreciated!!!

  134. Lewis Pixeled
    Lewis Pixeled March 12, 2013 at 9:49 pm

    Hi David,

    Thanks for the information,

    I actually do not have a link, because I’m developing on localhost, but I’ll check my functions.php carefully and try it again.

    Reply
  135. Lewis Pixeled
    Lewis Pixeled March 10, 2013 at 5:53 pm

    This doesn’t seem to work with me;

    I am using a multi-page form; is this the reason?

    The form goes blank, when I add the code. As for the ‘count_field_id’ parameter, what type of field should this be? A single line field?

    I am using a date picker field on both ‘start_field_id’ & ‘end_field_id’ parameters.

    Also does the opening ‘<?php’ tag need to be there for this snippet to work? It’s causing a syntax error with other functions in my functions.php

    I am using the latest Gravity Forms version also.

    Thanks for the help in advance!

    Reply
    1. David Smith
      David Smith Staff March 11, 2013 at 1:55 pm

      Hi Lewis,

      The opening ‘<?php’ tag is simply to indicate that the code is PHP code. If you are pasting this in your theme’s functions.php file and an opening PHP tag is already present, you can safely ditch this from the beginning of the snippet.

      The ‘count_field_id’ is not limited to a specific field type but is probably best used as a single line text, hidden or number field.

      I just tested this snippet on a multi-page form and it worked without issue. Do you have a link to the form you are developing?

    1. David Smith
      David Smith Staff March 11, 2013 at 1:59 pm

      Thanks for the suggestion. If I get enough interest, I’ll be happy to add support for this date field type as well.

    2. Kai
      Kai August 9, 2013 at 6:58 am

      Hi David, your snippet has helped me to solve a big problem in an easy way. Much appreciated. However, I found out the “Date Picker” does not always work to supply an accurate price. Would you consider publishing a snippet with “Date Drop Down” anytime soon? Cheers.

  136. geo chris
    geo chris March 5, 2013 at 7:11 pm

    i am very close. i want to build a car rental system! and transfer systemn the transfers is in the finish! i take the range of day, i create my price…. but the price is not change if the user change the months..

    Reply
  137. geo chris
    geo chris March 4, 2013 at 6:19 pm

    hi men….. your snip is the best!!!:) i want to ask if this snipet cant work with month if the price in january is 10 e on september is 15 e! he can calculate?

    Reply
    1. David Smith
      David Smith Staff March 4, 2013 at 6:39 pm

      Hi Chris, it sounds like what you want to do is conditional logic based on the current month. Is that right? If so, this tutorial will get you started:

      https://gravitywiz.com/use-gravity-forms-conditional-logic-with-dates/

      1 – Use this snippet instead of the one provided in the tutorial: http://snippi.com/s/mtvseuc

      2 – Instead of “Setting Up Time Stamp Field” you’ll be “Setting Up Current Month Field”, only difference is instead of using “timestamp” as the dynamic populate parameter, you’ll want to use “current_month”.

      3 – When you get to “Setting Up Conditional Field”, you’ll just need to remember that you aren’t working with a time stamp, you are working with the month as a number (ie January = 1, February = 2, March = 3, etc). Here is an example of a product field that will only show up in the month of November: http://grab.by/kpQE

      If anyone else is trying to do this and finds it useful, I’m happy to write up a full article.

  138. Brendon
    Brendon March 4, 2013 at 11:58 am

    Hey David,

    This is an awesome snippet. I’m having a little bit of an issue when I load this into my functions.php file. It seems to break the form completely, this is probably something I am doing, but could you give me a hand with correctly implementing it?

    Reply
  139. David
    David March 3, 2013 at 5:51 am

    Hi David, wow, awesome! Just what I need, however when I use this picking one night (two days) it calculates 32… I think it has to do with my dates being dd/mm/yyyy, not mm/dd/yyyy?? can you suggest a work around please, I would ideally like to keep the dates displaying dd/mm/yyyy…

    Also when I tested the mm/dd/yyyy theory the “nights only” code option doesn’t seem to calculate correctly, eg if I pick 1st March for day one and 2nd March for day 2 it gives a calculated total of 2 (whereas I want the total to read 1). Thank you in advance for your help

    Reply
    1. David Smith
      David Smith Staff March 3, 2013 at 1:46 pm

      Hi David, I’ve updated the snippet to better support the different date formats and fixed the issue where the “nights only” option was not working. Give it a go and let me know how it goes. :)

  140. Gary Armstrong
    Gary Armstrong March 2, 2013 at 2:36 pm

    Can I use two of these? That is, I want the user to put in a date. I want to calculate the number of days between that date and the date the form is opened. Then, I have conditional logic based on the size of that field. The question is, can I then repeat that process with subsequent sets of dates?

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

  • Trouble installing this snippet? See our troubleshooting tips.
  • Need to include code? Create a gist and link to it in your comment.
  • Reporting a bug? Provide a URL where this issue can be recreated.

By commenting, I understand that I may receive emails related to Gravity Wiz and can unsubscribe at any time.

Download Snippet

Calculate Number of Days Between Two Dates

This field is for validation purposes and should be left unchanged.