Question

how can I find the weeks between two dates using xpath?

1

Hi I need to find the weeks that elapased after a particular date, but the weeksBetween function doesn't work in xpath. is there another similar function or way to get around this? LR.

asked 2011-07-21

Luis Rodrigues (hotmail)

3 answers

Jan Doggen · Answer 1 · 2011-07-21

It sounds as if you want to retrieve other data than is in your database (weeks between is not in your DB). XPath is not for that, it's a filter. What do you want to accomplish?

Jonathan Veldhuizen · Answer 2 · 2011-07-21

In XPath, you can only retrieve MendixObject instances, simple attribute values or aggregated values. To find the weeks elapsed after a date, you can execute OQL queries with the function DATEPART in Java.

It is possible to use date part functions in XPath, but only in constraints, such as week-from-dateTime, see https://world.mendix.com/display/NRG/XPath+week-from-dateTime.

Luis Rodrigues (hotmail) · Answer 3 · 2011-07-22

the solution is on this post. Thanks for everyone's help.

using date subtraction in Xpath