Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Date variable - add a year. Can someone help ? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Date variable - add a year. Can someone help ?

Received Response
11
Views
2
Comments
edited Aug 17, 2021 4:14PM in Integration 2 comments

Summary

Oracle Integration Cloud - How do I create a date var and add a year?

Content

Hi folks

 

Hoping someone can show me how to do this as I'm losing my marbles trying thing after thing and getting errors every time.

 

If I output  string(fn:current-date()) I get 2021-08-17T15:23:52.198Z

 

So, I thought to create a date I would be able to define a variable in the same format as that, and then use +xsd:dayTimeDuration("P1Y") to add a year to it, but no, that will not work.

 

In the variable creation window :

I've tried xsd:dateTime('2021-08-17T15:23:52.198Z')+xsd:dayTimeDuration("P1Y") and this errors.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!