The Pragmatic Programmer

Appian, Pega, Java, DevSecOps, Quality Engineering

Date and Time Utilities

https://community.appian.com/b/appmarket/posts/date-and-time-utilities

I have a requirement that to display the month name & Year from two particular dates .

Is there any direct function or please give any valuable suggestions on the same.

Ex:11/2021 –10/2022

It should display Nov2021,Dec 2021…..Oct 2022

a!localVariables(
  local!startDate: todatetime("10/01/2021"),
  local!endDate: todatetime("12/27/2023"),
  a!forEach(
    items: enumerate(
      elapsedmonths(
        local!startDate,
        local!endDate
      )
    ),
    expression: text(
      addmonths(todatetime(local!startDate), fv!index),
      "MMMM YYYY"
    )
  )
)