Hi All,

Simply I want to do some arithmetic functions on date. I saw some functions have listed in Mapper Palette. But when I drag one function into the mapping area, it getting red as an error. I can't map it with another one further. Though I went through the references, I couldn't find a sufficient answer.

Let's say, I want to increase only the year by 5 on given date. Then how can I do it?

Thank You!

Hi,

Which designer build you are using?

Thanks,
Venkaiah.

Sorry for the disturbance. Actually I forgot to mention it before.

Designer (linux)- 5.1.0.022
Server - 5.1.0.019

Thank You!

Sorry for the disturbance. Actually I forgot to mention it before.

Designer (linux)- 5.1.0.022
Server - 5.1.0.019

Thank You!

Simple arithmetic on dates can be done with the date defined as xs:date and the increment as xs:duration (see here) so adding 5 years to the current date is created in mapper as:

current-dateTime()+"P5Y"

[UPDATE ... while you can enter that ok into mapper, or assign a "P5Y" into a duration type variable, the result does not execute ... I get
current-date() + $dur)}": Error while executing an XPath expression: net.sf.saxon.trans.DynamicError: Unsuitable operands for arithmetic operation (xs:date, xdt:untypedAtomic)]

Thank You dfrench...

But still the problem is remain. When I draw "current-dateTime()+"P5Y"" in mapper area, still it is red colored. I can't map it to the right field.

Suppose that user has entered a date already. We have to add years for that. Then the mapping will be how?

Thank You!

Hi All,

Still the problem is remain. Can anybody help me on this matter. Please.

Thank You!

Hi,

Some functions were not implemented in the 5.1 builds.
Could you please try with the latest 5.2 builds.
I hope it will resolve your issue.

Thanks,
Venkaiah.

my problems were with 5.2.0.091

Hi All,

I have installed designer 5.2 and trying to do the date arithmetics.

But which function should i use to add some years to given date? And how should I do the mapping part?

Thank You!

Hi,

You can use the xpath function available under Mapper Palette for duration and date.


Thanks,
Venkaiah.

Perhaps you could take the time to show how you achieve this.
The attached project has a variable of type xs:duration which is added to the result of the current-date() function. This is a valid arithmetic function on date and duration type and is validated by designer BUT fails in execution.

Code: :

An exception occured while evaluating "{OXPath10Expression current-date() + $dur}": Error while executing an XPath expression: net.sf.saxon.trans.DynamicError: Unsuitable operands for arithmetic operation (xs:date, xdt:untypedAtomic)

This is certainly a bug, if only because invalid operands should be detected in Designer but the execution seems to be misinterpreting the type.