| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Trying to pull the data for current date - Query
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use MS Query to query data within the current work book | Excel Discussion (Misc queries) | |||
| Stock query can't pull more than 10 years of data | Excel Worksheet Functions | |||
| Pull parameter from worksheet for External Data Query to SQL Datab | Excel Discussion (Misc queries) | |||
| How do I enter a date range ie -7 from current date in MS QUERY | Excel Discussion (Misc queries) | |||
| Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Threaded Mode
