Date manipulation

  • Thread starter Thread starter steve
  • Start date Start date
S

steve

I would like to use a date entered on a form in a query
and retrieve statistics based on that corresponding week,
month, previous month, and year. Do I have to convert
the text entered to a date field somehow and then
subtract 30 from it to get the previous month? I would
also like to retrieve the month "literal" (ie. August)
based on this "new" date. I have the week, month, and
year fields down, but the "previous" month is giving me
problems. I have tried this different ways but always
get a syntax error. Any ideas?
 
Check out the DateAdd function and the Month function. Together, you can use
them to do what you seek! Both are described in Help file. If you need
assistance or have questions, post back!
 
Back
Top