Hi all
i have a field "Num (Entry) as Entry" with dates of from 44562(01/01/2022) to 44924(29/12/2022). But here i need a new column of "[Rolling Last 3 Months]", in this column result will be show from 44924 (29/12/2022) to 44833 (29/09/2022). for this i have tried this way......
Tmp:
Load *,
If (num(floor (Entry))=Num (AddMonths (today (),-3)),
1,
0) as [Rolling Last 3 Months]
Resident Table;
Drop Table Table;
But here while i select '1' from Rolling last 3 months field, the rusult shown only 44833(29/09/2022)
The expected result is from 44924(29/12/2022) to 44833(29/09/2022)
Can you guys suggest me where I was wrong here.
Thanks in advance.
