Hi i am using bo 6.5.1 ,
i have a report with a prompts which ask the user to enter the start date and end dates,
so what i want is that when that prompts shows up everytime, in the start date it should display always the beginning date of the year eg 1-1-06 and end date should be today’s date 2-13-06( date when that report is run)
user should also have the facility to change those default dates
how can we do that??
thanks
Well…you can use the UserResponse() function to access the dates that are entered at the prompts. Remember that they will be stored in character format, so you’ll need to convert them to dates. You could then do something like use the Year() function on the start date and concatentate that with 01/01/. So far as the end date goes you could use the function CurrentDate() or you could use the LastExecutionDate() function.
how can we use CurrentDay() , LastExecutionDate() functions with the existing prompts,remember it has to be a prompt ans these has been made in designer 6.5.1.
thanks