Converting Days into years

(0) Share

Report

Posted on by kat7777777

112

Hi,

I have a canvas app I am building. I want the user to be able to select a date that they started at an organization from a date picker. Then I want it to automatically calculate the number of whole years/half years that they have been employed.

The formula I currently have works but it only calculates whole years, not the half years as well. Any tips? Below is the formula. DatacardValue11 contains the date the user is selecting, TextInput1 contains today's date.

With({_start: DateValue(DataCardValue11.SelectedDate), _end: TextInput1.Text},
Year(_end) - Year(_start) -1 +
If(DateDiff(Date(Year(2020), Month(_end), Day(_end)), Date(Year(2020), Month(_start), Day(_start)))>0, 0, 1)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

SebS 4,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@kat7777777

Try this one just replace Controls to fit them to Yours

With({_start: DateValue(DatePickerCanvas1.SelectedDate), _end: DateValue(TextInputCanvas1.Value)}, Year(_end) - Year(_start) - 1 + If(DateDiff(Date(Year(2020), Month(_end), Day(_end)), Date(Year(2020), Month(_start), Day(_start))) > 0, 0, 1) + If(Mod(DateDiff(_start, _end, TimeUnit.Days), 365) >= 182.5, 0.5, 0) )

Was this reply helpful? Yes No
SebS 4,803 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@kat7777777

But I switched also _Start with _End

With({_end: DateValue(DatePickerCanvas1.SelectedDate), _start: DateValue(TextInputCanvas1.Value)}, Year(_end) - Year(_start) - 1 + If(DateDiff(Date(Year(2020), Month(_end), Day(_end)), Date(Year(2020), Month(_start), Day(_start))) > 0, 0, 1) + If(Mod(DateDiff(_start, _end, TimeUnit.Days), 365) >= 182.5, 0.5, 0) )

Was this reply helpful? Yes No
kat7777777 112 on at

Like (0)

Report
Copy link

Link copied!

This works! Thank you for your help!!

Was this reply helpful? Yes No