Calculation Criteria on Join Date Field

[Jimmy24]

Dear Sir or Madam,

I need to pulled data where that will includes all members that with join_date is greater than specific date.

Example: All member with join_date greater than 11/12/2005.

Select *
From Members
Where ?????????

Thank you for your assistance

Jim

 

[AlexCuse]

JOIN_DATE > '2005-11-12' ?

It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.

 

[gmmastros]

We can help, but we need more information to do so. Please run the following query and paste the information back in to this thread.

select 	Data_Type
From 	Information_Schema.Columns
Where	Table_Name = 'Members'
        And Column_Name = 'join_date'

This code should be run in query analyzer.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[harebrain]

And think midnight, Alex...

 

[AlexCuse]

Duh!

JOIN_DATE > '2005-11-12 23:59:59'

Thanks harebrain, guess I was a little lazy on that one!

This all of course is dependent on whether or not you have a bona fide date field or a char field, as George's code will point out.

Hope this Helps,

Alex


It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.