Skip to main content
K
karthikeyans1785
September 11, 2023
Question

not able to pass calculated date time value in elapsedmonths function

  • September 11, 2023
  • 1 reply
  • 0 views

local!quarterFindFactor:roundup((month(today())/3),0),

local!startingQuarterdate:todatetime({eomonth(datetime(year(today()) - 3, 12, 31),- local!quarterFindFactor) + 1}),

local!end: todatetime(now()),

enumerate(elapsedmonths(local!startingQuarterdate, local!end)+1)

if i pass the hardcoded value then it is working fine. If i use the above code it is throwing the below error.

Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function 'elapsedmonths' [line 13]: The passed parameter(s) are of the wrong type. Received the type com.appiancorp.common.xml.JaxbConversionException: JAXB failure trying to convert typed value TypedValue[it=109,v={2020-10-01 00:00:00.0}] to java class java.sql.Timestamp.

Pls any suggestions

    1 reply

    stefanhelzle0001
    stefanhelzle0001
    September 11, 2023

    The line below creates a list of values. This turns the value into a list. elapsedmonths() does not like lists. If you need to process that list, use a foreach.

    local!startingQuarterdate:todatetime({eomonth(datetime(year(today()) - 3, 12, 31),- local!quarterFindFactor) + 1}),

    Terms & ConditionsAccessibility statement