Content

Web calculators case studies #4 – Date field and functions Part 2

Date calculations are now available with Calculoid. We added Date field and 5 date functions to the formula field. Let's take a quick look at how can you use it in your calculators.

 

Explore case studies and get inspired on how to use Date field and functions to grow your business in Calculoid webinar recording.

Watch webinar recording

 

Imagine creating a calculator that needs to calculate the difference between the starting date and today's date. All you need is to add a Date field to your calculator where the start date can be selected and two formula fields for today's date and further calculations.

One of the formula fields will be used for showing today's date using todayDate function. This is a better way than forcing your clients to select today's date manually. It is also nice to use formatDate function with todayDate to present the result in a custom format.

Description of todayDate function: todayDate().

Online Store Calculator Template - Calculoid.com

Case study 1 – Two getTime functions to get the difference between two dates in days  

 

To find the difference between two dates we need getTime function. This date function returns date in the absolute format presented in milliseconds.

Description of getTime function: getTime(date). Date can be taken from a date field or a formula field.

To calculate how many days are gone from the starting date till now we need to take today's date from the formula field and use getTime function. Then do the same with the date from the date field and take the second number from the first one.

Example: getTime (Today Date) - getTime (Start Date)

 

Online Store Calculator Template - Calculoid.com

The result is now in milliseconds. To present it in days we need to divide the number by 86,400,000.

Calculoid webinar recording

Additional information

Start Free Now

Create your own web calculator in a matter of minutes.
Test all features in the 30-day free trial. 

Sign Up Free

No credit card or installation needed