I have a start date and an end date. I have a drop down for each and it shows all dates available back to 1991. I want to limit the date to more recent dates for the user to select from. I'm told it has to be handled in the source tab and not in the where/if area. How can I limit the dates available to 2005 and greater?

This message has been edited. Last edited by: Kerry,

You definitely do not need to do anything in the source. Just set the range appropriately.

I saw the range option, but I want the user to be able to pull the most recent date available. If I select the most recent date today as the end of the range the new records wont be available next time will they?

It sounds like you want to limit the dropdown list that users can choose from.

There are a few ways to do that the easiest though is to use the HTML Composer and on the drop down and filter what shows up.

If you don't want to deal with HTML Composer here is a post that may help.
http://forums.informationbuild...1060942?r=2551080942

If I am wrong and you want the dropdown list to still show everything but make sure users only select newer dates can use labels and gotos if they are before 2005:

-IF EDIT('&START_DATE','9999') LT '2005' OR EDIT('&END_DATE','9999') LT '2005' THEN GOTO LBLERROR ELSE GOTO LBLCONT;
-LBLERROR
-TYPE Must select dates from the year 2005 or later.
-EXIT

-LBLCONT

The above I am not able to test at the moment but should work. If the user enters one or both of the parameters with a date before 2005 it will not run the report and give the user the -TYPE message else it runs the report as normal. This would go before your first TABLE, DEFINE, or JOIN in your report.

The range can be relative so it changes as time changes.

You are right Crymsyn that is exactly what i want to do. I am going to use the HTML composer and its calendar function to run the fex as some did in the link you provided. Thanks for your help with this.