I have a report that shows result based on period (e.g: 1 month period, 2 month period...). I try to query and come out like this. As i would like to get record 1 month from current date 

```
SELECT printed_serial,[name],last_active_date
FROM #Temp t
INNER JOIN [dbfastsconfigdataref].[dbo].[cdf_micard] mi on mi.cu_id = t.cu_id
INNER JOIN [dbfastsconfigdataref].[dbo].[cdf_ch_cuid] chcu on chcu.cu_id = t.cu_id
INNER JOIN [dbfastsconfigdataref].[dbo].[cdf_ch] ch on ch.ch_id = chcu.ch_id
WHERE last_active_date <= DATEADD(month, -1, getdate())

```

with result:

```
card id    name    last_active_date 
0110       Sara    jan 4 2019 4:15 pm
0111       Ara     Nov 26 2013 12:22 am

```

but expected result :

```
card id    name    last_active_date 
0110       Sara    jan 4 2019 4:15 pm

```