Please refer below code
SQL
Create Table #Users1
(
FName varchar (50),
LName Varchar (50),
Number varchar(10),
CreateDate Datetime
)
INSERT INTO #Users1 Values ('AAAA','A','11111','05-25-2016 00:10:000')
INSERT INTO #Users1 Values ('BBBB','B','22222','05-25-2016 01:18:000')
INSERT INTO #Users1 Values ('CCCC','C','33333','05-25-2016 06:10:000')
INSERT INTO #Users1 Values ('DDDD','D','44444','06-25-2016 06:10:000')
INSERT INTO #Users1 Values ('EEEE','E','55555','06-25-2016 23:10:000')
INSERT INTO #Users1 Values ('FFFF','F','66666','06-25-2016 00:01:000')
INSERT INTO #Users1 Values ('FFFF','G','77777','06-26-2016 00:01:000')
INSERT INTO #Users1 Values ('FFFF','H','88888','06-26-2016 16:01:000')
INSERT INTO #Users1 Values ('FFFF','F','99999','06-26-2016 23:01:000')
SELECT * FROM #Users1
WHERE CreateDate BETWEEN DATEADD(MM, DATEDIFF(MM,0,getdate())-1, 0) AND DATEADD(DD,-1,DATEADD(MM, DATEDIFF(MM,0,getdate()), 0))
DROP TABLE #Users1
