NB: Make sure you do a back up of your theme, files and database before attempting the tutorials

Calculate the Number of Days between Two Dates
Easy

---- Last modified : Mar 24 2022

With this tutorial, we will show you how to calculate the number of days between two dates. And with our example, We will also see an example of mathematical calculation with a Formidable form shortcode.

Let’s create a shortcode to calculate the number of days.

Calculate the number of days between two dates

function themespress_numberdays_shortcode() { 
     $now = time(); // Current time 
     $your_date = strtotime('2022-01-23'); // The first date
     $datediff = abs($now - $your_date); // Gives absolute Value 
     return floor($datediff/(60*60*24)); // Returns the lowest value by rounding down value 
} 
// register shortcode
add_shortcode('numberdays', 'themespress_numberdays_shortcode'); 

Our date ‘2022-01-23′ will be the start date and the variable $now represents the current time. Afterwards, we need to calculate the number of days between two dates.

We can do calculations and statistics with the following Formidable Form shortcode:

[frm-math][/frm-math]

With this mathematical shortcode, we will insert the data to calculate. For example, we want to calculate the daily grocery expenses between two dates.

For example, you can create a Formidable Form to include grocery expenses.

Form fields:

1 – A hidden field with the default value of the date where the entry was created [date]

2 – Select Options field with various grocery stores (Ex: Costco, Walmart, etc…)

3 – A number field with the amount

Formidable Form - Exemple formulaire

After adding some data, you can proceed with the calculation with two shortcodes:

1 – We want to obtain the amount total (with entry ID) that will be the ID of my amount field.

// Remplacez 321 par l'ID de votre entrée montant.
[frm-stats id=321 type=total]

2 – The shortcode for which calculates the number of days with the function created above. [numberdays].

// Fonction de notre calcul du nombre de jours.
[numberdays]

Now, calculate the results on one of your pages:

// Remplacez 321 par l'ID de votre entrée montant.
[frm-math][frm-stats id=321 type=total] / [numberdays][/frm-math]

With Formidable Form, you can generate charts to display your results.

Exemple de graphique formidable form
// Remplacez 320 par l'ID du champ select options des supermarchés
[frm-graph fields="320" type="column" data_type="total"]

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>