jing tung wong
Rank: #33495
6Views
1Comments
Solved
how to set the filter if I wan data which is more than 2 months from current date
Question
SQL
Reactive

how to set the filter if want visit.createdon < 2 months from current date?

it will only list the data which DEC 2020, NOV 2020, OCT 2020 ......



XXXXXX FEB 2021 , 2021 JAN DON'T NEED TO SHOW

filter.png

0
0
on 9th Feb
Copy link to comment
jing tung wong
Rank: #33495
Solution
I found myself..

Visit.CreatedOn < AddMonths(CurrDateTime(),-2)
0
0
on 9th Feb
Copy link to comment