using DatePicker Year Month, once the month and year are chosen, how would I be able to calculate how many months (or days) have elapsed from today?

Hello team, using DatePicker Year Month, once the month and year are chosen, how would I be able to calculate how many months (or days) have elapsed from today?

Hi JuanCarvaljal,

A simple way to achieve this is by creating a simple condition that will subtract one date from another.

First you need to create 3 fields.

1. Date picker for Date Selection
2. Date picker that will present the current date
3. Short text that will display the days elapsed.

For number 2, you can have it automatically pick the current date by going into the Settings, tab over to Options, and change Date Default to Current.

Next, you want to create a simple condition, by going into Settings at the top, and then to Conditions,  and add a "Update/Calculate Field" condition.

From there you can create this simple calculation...

If Date picked is filled, Do Calculate field value " Date picked - Present Date", summary will go to the Days Elapsed short text field.

The result will look something like this.

Give that a try and let us know if you have any other issues.