Showing all gifts for the last 12 months
Ninox Profile

I am trying to create a Kanban or card view that displays all donations given in the last 12 months, sorted by month. The sorting isn't difficult, but I've always struggled with the code for displaying time periods in Ninox. I think the formula would look something like this (but definitely not EXACTLY like this):

yearmonth('Date Given') :=< today - 365

Ninox Profile

youcan use the filter  from and to for a date

Ninox Profile

I'm not sure if this will help. You can get a list of twelve last months with this code:


let d := today();
for m from 0 to 12 do
yearmonth(date(year(d) - 1, month(d) + m, 1))
end


Today is 2019/07/17 so the code gives next list:


2018/07
2018/08
2018/09
2018/10
2018/11
2018/12
2019/01
2019/02
2019/03
2019/04
2019/05
2019/06

Ninox Profile

Use someting like the following for the base of the view  assuming you are using a year month boundary.   Assume you have a table named Gifts.. and on that table you have your column 'Date Given'... You can use the following select as the base of the view. 

let t:= today();
let endDate := yearmonth(t);
let startDate := yearmonth(date(year(t)-1, month(t), day(t)));
select Gifts [yearmonth('Date Given') >= startDate and yearmonth('Date Given') <= endDate]

Reply