What product????
When you say date "would vary depending on what is selected on the prompt page" do you mean it's a parameter?
If Report Studio, if parameter: put the parameter in a data item, put the data item on your report, use Data Format properties to format it the way you want. The fact...