Difference of End - Start Dates Differ in 2 Column

Ask for Help
1

Dear Community,

We noticed there are differences in the computed values when we deduct 2 dates column (similar columns) for both EC Calc & cal_No.of Years.

EC Calc
EC Calc889Ă—1039 75.3 KB

Notice the above EC Calc, the value shown is X years. The value in cal_No_EC_Years is in decimal.

EC Calc
EC Calc889Ă—1039 75.3 KB

Both the start and end dates are Date Only - Medium.

no. years
no. years1038Ă—993 89.7 KB

2

To subtract one date from another and get a result in decimal years, you need to use the following:

Round(End-Start)/365

Screen Shot 2022-09-10 at 4.47.37 PM
Screen Shot 2022-09-10 at 4.47.37 PM1214Ă—712 85.7 KB

3

Got it…

But in my screenshot above, Notice the ROund wasn’t in both the screenshots, and yet the first column has a “years”

4

Isn’t that just the display units that you’ve set in the math column?

5

The left column has a “years” showing.

no. years
no. years1038Ă—993 89.7 KB

6

Yes, and I assume that’s because it’s what you have set as the display units?

Screen Shot 2022-09-10 at 5.52.55 PM
Screen Shot 2022-09-10 at 5.52.55 PM790Ă—906 66.8 KB

7

You showed the EC_Calc configuration twice. How did you set up cal_No_EC_Years?

1 Like