Dataset OQL and DateDiff with RangeBegin

0
I’m trying to use this expression in my “where” clause; the OQL processor at compile doesn’t seem to like it? $ToDt below is constrained to last month. So I basically want to take the last 12 months. datediff(MONTH, ACC/PDt, RANGEEND($ToDt)) <= 12
asked
2 answers
1

May be you want:

AC/PlacedDt >= addMonths([%EndOfCurrentMonth%], -13)

answered
0

I found a workaround that seems to work … How can I display the token on my SELECT clause? I tried to use a microflow to display the value because I wanted to verify what it was, particularly  '[%EndOfCurrentMonth%] - 13 * [%MonthLength%]' …. But the microflow didn’t like %MonthLength%?

 

AC/PlacedDt <  '[%BeginOfCurrentMonth%]'  and AC/PlacedDt >= '[%EndOfCurrentMonth%] - 13 * [%MonthLength%]'

answered