Displaying Previous Month and Last 12 Month based on UserResponse

Hi All Guru,

I am currently doing two reports in which i need to show the following result :

1. Show Last Month Data based on user input from the prompt, and this report is created in table format.

2. Show Last 12 month Data based on user input from the prompt, and this report is created in crosstab format.

Problems:

For report number 1:

I have try to create a variable with the following formula:

=FormatDate(ToDate(UserResponse("Enter Value(s) for Successful Date:"); MM/dd/yyyy hh:mm:ss ");"MM-yyyy")

Am not sure this is a correct method or not. The current date format is come in date time format. I would like to display it as this "JAN-2008"). For example: If the user select a calendar based on the prompt, and the date is 01 Nov 2013 10:00:00, I would like my report to display the last month record which just show Oct-2013. Meaning i am day and timestamp).

For report number 2:

I would like to know how to show the result if user selection was 01-Nov-2013 10:00:00, i would like to show last 12 month based on the user input. For example, Oct 2013, Sep 2013 and etc.

By the way, i am doing this in WEBI level as i have no access to Universe.

Regards,

Joe