An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Retrieving records from ms access for specific dates
Given an MD Access DB with records containing a date, how can retrieve the records for a specific date? I know how to use the dateadd function to pull the records using the (-) days approach.
I want to pull records for the past 24 days, one day at a time. How can I do that?
for rw as integer =24 to 0 step -1
sql="select * from history where type='cycle' and cycle_date = '" & ???????
next
Any ideas?
I want to pull records for the past 24 days, one day at a time. How can I do that?
for rw as integer =24 to 0 step -1
sql="select * from history where type='cycle' and cycle_date = '" & ???????
next
Any ideas?
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
sql = "select * from cycle_history where cycle_type='cycle' and job_number='" & jobno & "' and cycle_time >= dateadd(""d"",0,#" & Now.Date.AddDays(-dy) & "#) and cycle_time < dateadd(""d"",0,#" & Now.Date.AddDays(-dy + 1) & "#) order by cycle_time desc"