×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Searching for data by day of the week, but need last full month

Searching for data by day of the week, but need last full month

Searching for data by day of the week, but need last full month

(OP)
I got help last week with a problem looking for data for specific days of the week. Someone answered and suggested the following formula to retrieve data for Sunday & Saturday.
{CollectDate} in dateadd("ww",-4,currentdate) to
currentdate and dayofweek(collectDate) in [1,7]

This formula worked, but I only retrieved data from the last week of Sepember. I need the full month of September. Can anyone help?

Thanks... Rosy1

RE: Searching for data by day of the week, but need last full month

This should do the trick:

{CollectDate} In LastFullMonth

RE: Searching for data by day of the week, but need last full month

(OP)
I did that in the original formula. But I still only get the last weekend of the month.
This is what I entered:
{@date} and
{CrossReference_VIEW.CollectDateODBC} in LastFullMonth and
{CrossReference_VIEW.TestCode} like "CFX", "HEXPA", "HPIA"

Any other suggestions?  Thanks... Rosy1

RE: Searching for data by day of the week, but need last full month

Is that only a partial record select statement?  What does {@date} do?  Also, {@date} won't be passed to the DB server without certain steps.

Try removing all other criteria except

{CrossReference_VIEW.CollectDateODBC} in LastFullMonth

to see if you are returning the right data.  Then add in other criteria to see how your dataset is affected.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close