Trying to pull the data for current date - Query

[Viol-8-r]

Hello Folks,

It is a simple query but I am just stuck. I am trying to pull the data for current day and writing the query below

select *from pop30300 WHERE POPTYPE = 1 and receiptdate = GETDATE() order by poprctnm asc



But it is not correct. Please help. I need the date for today date on daily basis.

 

[smartin]

Hello Folks,

It is a simple query but I am just stuck. I am trying to pull the data
for current day and writing the query below

select *from pop30300 WHERE POPTYPE = 1 and receiptdate = GETDATE()
order by poprctnm asc



But it is not correct. Please help. I need the date for today date on
daily basis.

This is not really an Excel matter is it? Your question would be better
answered in a group related to the kind of database you are querying,
since the formula/syntax for <what is the current date?> depends on the
DB platform.

Best of luck.