I am trying to write some queries that return objects modified or created in specific time frames. For example:
Right now, I only know how to query for objects created/modified today using the "&CurrentDate" parameter.
For example, here is a query that returns all diagrams modified today
Select Diagram WHERE [Modification Date] >= "&CurrentDate"
Now, what I would like is to have a query that returns diagrams modified in "past 7 days" or "past 14" days etc..
Is there any special keywords for this in HOPEX, or are any calculations allowed and if so - how?
Solved! Go to Solution.
ERQL doesn't offer this kind of capability today. You can only use system variable : &CurrentDate
But you can implement a query by a macro.
As far as I know, you would have to create query with a macro implementation.
For example, for the implementation :
Sub FillSelectionCollection(mgobjObject as MegaObject, vntSelectorID as Variant, mgcolCollection as MegaCollection)
Dim mgRoot, col
mgRoot = mgobjObject.getroot
col = mgRoot.getSelection("Select [Diagram] where [Modification Date] > '" & CDate(Now-7) & "'")
Hope this can help.
@PBessodes Are you able to offer any help on this question?
I am writing some queries - and would really like to be able to have a way to return results "from last week" or "last month" or something like that.