Skip to main content
tejasn0320
tejasn0320
January 31, 2024
Solved

Calculate Months and years form Date difference

  • January 31, 2024
  • 8 replies
  • 0 views

Hi

I want to Calculate the date difference in to Months and years 

form given dates 

date1: 15 Jan 2022

date2: 15 Jan 2024

date2-date1

ANS= 2 years

In Appian date difference 

date2-date1 is calculating only days 

730

Best answer by venkatrea696188

Hi [mention:ae9ebe781c79465582221db39f6b7db9:e9ed411860ed4f2ba0265705b8793d05]  

There isn't any OOTB functionality to achieve your requirement , But you can use elapsed Years or elapsed Months functions which are available in "DATE AND TIME UTILITIES". Plugin . Or you can write your own mathematical calculations.

8 replies

harshitb6843
harshitb6843
January 31, 2024

Divide it by 365?

tointeger(date(2024,1,15)-date(2022,1,15))/365

venkatrea696188
venkatrea696188Answer
January 31, 2024

Hi [mention:ae9ebe781c79465582221db39f6b7db9:e9ed411860ed4f2ba0265705b8793d05]  

There isn't any OOTB functionality to achieve your requirement , But you can use elapsed Years or elapsed Months functions which are available in "DATE AND TIME UTILITIES". Plugin . Or you can write your own mathematical calculations.

    mathieud0001
    mathieud0001
    February 1, 2024

    Take a look at this plugin: community.appian.com/.../date-and-time-utilities

      tejasn0320
      tejasn0320Author
      February 1, 2024

      a!localVariables(
  local!months: elapsedMonths(ri!date2, ri!date1) - ri!gapInMonths,
  if(
    local!months > 12,
    a!localVariables(
      local!month: mod(local!months, 12),
      local!years: quotient(local!months, 12),
      local!years & " Years " & local!month & " Months"
    ),
    local!months & " Months"
  )
)



      Thank you for your comments. I utilized date and time utilities and developed the necessary logic.

        R
        ramnadhs
        January 23, 2025

        can we get days along with years and months ?

        venkatrea696188
        venkatrea696188
        January 23, 2025

        Yeah Use elapsed time and play with result .Here is a Sample code for you

        a!localVariables(
  local!difference:elapsedtime(todatetime(ri!date1),todatetime(ri!date2)),
concat(
  local!difference[1], " Years ",local!difference[2], " difference ", local!difference[3], " Days"
)
)

        Terms & ConditionsAccessibility statement