Page 1 of 1

get date from week number

Posted: Tue Feb 19, 2019 12:44 pm
by SteffenWeitsch

is there any possibility to get first and last day of a week number in XQuery ?
As input I have date formatted CCYYWW and want to get CCYYMMDD - CCYYMMDD

I also thought about option to implement java calendar but I failed in using java.
Calendar cal = Calendar.getInstance();
cal.set(Calendar.WEEK_OF_YEAR, 23);
cal.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY);

So if there is no XQuery function how can I use java calendar ?

Thanks for help.


Re: gate date from week number

Posted: Tue Feb 19, 2019 2:36 pm
by Radu
Hi Steffen,

We (the Oxygen team) do not work much internally with XQuery.
There seems to be quite a large collection of XQuery functions here:

You can also try to call Java methods directly in XQuery: ... thods.html