Represent day difference in fetch filter


#1

Hi,

How can I represent a day difference and then apply an order relation on?
I am trying something like:

BillPlanning.fetch({include:include, filter:"((end - start) / period(1,'DAY')) >200", limit:1})

Thanks in advance.


#2

Problem solver, using toMillis

((toMillis(end)- toMillis(start)) / 86400000)<200"