• Please first tell me. Are you currently using SQL Server Yukon?

    Here is the answer to your question with assumption of SQL2K in use.

    Create views with different date ranges. You should able to provide two different column names in the two different views. If you provide more details of what compell you to use different column names for two diffent date range; I might be able to suggest you couple of work arounds.