SQL. Query for vba

Question

I have a table that has more than one date fields (say six or seven) and I just want to retrieve only the dates that match today's date. Please help. Really appreciate it thanks

Please share some code or use GETDATE() function to map your field with the current date — Harsha W
– Harsha W, Commented May 8, 2017 at 10:56
Would you mind being more specific about it. Sorry I am just a rookie pitcher. Thanks — antony samid
– antony samid, Commented May 8, 2017 at 11:01
Please post your SQL table structure here. Then I can give you the exact answer. — Harsha W
– Harsha W, Commented May 8, 2017 at 11:04
@HarshaW GetDate() in Access? can you not go with where yourdatefield = DATE() OR yourotherdatefield = DATE()..... or if you want all the fields to = todays date use AND instead of OR (DATE() gives you todays date) — Fred
– Fred, Commented May 8, 2017 at 11:04
Hey Fred - I did similar to what you suggest here but no record we're in the result — antony samid
– antony samid, Commented May 8, 2017 at 11:40

JCalcines · Accepted Answer · 2017-05-08 11:31:47Z

1

This is a very specific problem, so the best way to get the result you want is to code some part as an script on access.

For getting those rows where at least one date is the same as today's date, you should use something like this.

SELECT * FROM Table t
WHERE Date() IN (t.field1, t.field2, ...)

You should add all the fields you want to check inside IN clause.

On the Access for you should be able to process the data.

answered May 8, 2017 at 11:31

JCalcines

1,28612 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

antony samid Over a year ago

Great!! Harsha I'll check and let you know in case of any questions. Thanks a lot

antony samid Over a year ago

Hi there, I tried the following code (SELECT * FROM Table t WHERE Date() IN (t.field1, t.field2, ...) but it pulls all the dates which is not exactly expected. Your thoughts please

antony samid Over a year ago

actually what i need is that the result from the query should serve as a report and that report should show the project id and project title (the first two columns) along with only the dates that equal today's date. not all date fields are required in this result. the bottom line is that this result should act as Todo list for today. i guess i am clear about what i intend to get. Thanks

JCalcines Over a year ago

You should update your question with this new information

Collectives™ on Stack Overflow

SQL. Query for vba

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related