Selecting a date range where date parts are multiple columns
Selecting a date range where date parts are multiple columns
- Subject: Selecting a date range where date parts are multiple columns
- From: "Albert Jagnow" <email@hidden>
- Date: Thu, 13 Jan 2005 13:32:58 -0600
- Importance: normal
- Priority: normal
I am working with data from an old system and I am unable to alter the
table design. I have run across a rather strange table where the
designer of the table put the date information in multiple fields.
There is a year column a month column and day column. There is no one
column that contains complete date information. If I want to be able
to select records from this table that fall between two dates what is
the easiest way to do that?
--
Albert Jagnow
Web Developer
The University of Iowa Foundation
This e-mail (including any attachments) is covered by the Electronic
Communications Privacy Act, 18 USC. 2510-2521. It is confidential and
may be legally privileged. If you are not the intended recipient, you
are hereby notified that any retention, dissemination, distribution, or
copying of this communication is strictly prohibited. Please reply to
the sender that you have received the message in error, and then delete
it. Thank you.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden