Title: date calculation
Last modified: May 11, 2023

---

# date calculation

 *  Resolved [civilvicky](https://wordpress.org/support/users/civilvicky/)
 * (@civilvicky)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/date-calculation-8/)
 * Is it possible to get the date 100 days from today. For example if we have one
   date field in which by default the date will be current date. Another field will
   be calculated field where the date will be shown that is 100 days earlier from
   the current date.

Viewing 1 replies (of 1 total)

 *  Plugin Author [codepeople](https://wordpress.org/support/users/codepeople/)
 * (@codepeople)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/date-calculation-8/#post-16729804)
 * Hello [@civilvicky](https://wordpress.org/support/users/civilvicky/)
 * To get 100 days from today, you can insert a calculated field in the form and
   enter the equation:
 *     ```wp-block-code
       GETDATETIMESTRING(DATETIMESUM(TODAY(), 'dd/mm/yyyy', 100, 'd'), 'dd/mm/yyyy')
       ```
   
 * If instead of using the TODAY operation, you want to increase the value of the
   date field fieldname1, the equation would be simpler:
 *     ```wp-block-code
       CDATE(fieldname1+100,'dd/mm/yyyy')
       ```
   
 * To get earlier 100 days, the corresponding equations would be:
 *     ```wp-block-code
       GETDATETIMESTRING(DATETIMESUM(TODAY(), 'dd/mm/yyyy', -100, 'd'), 'dd/mm/yyyy')
       ```
   
 * and
 *     ```wp-block-code
       CDATE(fieldname1-100,'dd/mm/yyyy')
       ```
   
 * Best regards.

Viewing 1 replies (of 1 total)

The topic ‘date calculation’ is closed to new replies.

 * ![](https://ps.w.org/calculated-fields-form/assets/icon-256x256.jpg?rev=1734377)
 * [Calculated Fields Form](https://wordpress.org/plugins/calculated-fields-form/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/calculated-fields-form/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/calculated-fields-form/)
 * [Active Topics](https://wordpress.org/support/plugin/calculated-fields-form/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/calculated-fields-form/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/calculated-fields-form/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [codepeople](https://wordpress.org/support/users/codepeople/)
 * Last activity: [3 years, 1 month ago](https://wordpress.org/support/topic/date-calculation-8/#post-16729804)
 * Status: resolved