MedscapeEditorial
asked on
Querying a database to find where two fields are not equal
I'm sure I'm missing something obvious....
The task at hand:
Create a date driven report that shows everything that has been published within that date range that was supposed to publish in a different quarter (so it was either advanced or delayed)
Select Autonumber, Topic, Quarter: DatePart('q',Date_Posted), Quarter: DatePart('q',Date_Original Publish)
from TableStuff
Where the two date parts don't equal....
How do I write that WHERE clause?
The task at hand:
Create a date driven report that shows everything that has been published within that date range that was supposed to publish in a different quarter (so it was either advanced or delayed)
Select Autonumber, Topic, Quarter: DatePart('q',Date_Posted),
from TableStuff
Where the two date parts don't equal....
How do I write that WHERE clause?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Another great answer! Thank you for the prompt assistance
ASKER