Date parameter in OQL

Hi community, In my OQL query, I need to set a constraint on a date to filter objects which are in the past.   how can I get a date/time parameter working in OQL dataset ? if I add a parameter, it's automatically defined as a date range   Or maybe if there is a function to parse a date in OQL in Mendix 9.24 ? (string --> date) I couldn't find anything in the doc   thanks
1 answers


You have an 'execute OQL statement' activity in your microflow and there you want to just add a constraint on a date to for instance show only the records <= CurrentDate. Is that the case?

If so then please add 'Add Date Time Parameter' activity before the 'Execute OQL statement' and use it in the query.