Display count of current date records in SQL Server

Hi Bhavesh23,

Use where condition to apply current date.

Please refer below sample.

SQL

CREATE TABLE #UserTemp
(
	Id Int Identity Primary key,
	Name Varchar(50),
	Dates DateTime
)

INSERT INTO #UserTemp VALUES('Rohan Khan','2022/04/02')
INSERT INTO #UserTemp VALUES('Shivam Maurya','2022/04/01')
INSERT INTO #UserTemp VALUES('Lina Luther','2022/04/04')
INSERT INTO #UserTemp VALUES('Shyam Gupta','2022/04/01')
INSERT INTO #UserTemp VALUES('luna Khan','2022/04/03')

SELECT COUNT(*) FROM #UserTemp WHERE CONVERT(VARCHAR(100),Dates,103) = CONVERT(VARCHAR(100),GETDATE(),103)

DROP TABLE #UserTemp

Screenshot