need a date prompt

[Former Member]

Hi All,

I need to enter cut off date as prompt but this cut off date field is not existing in database. based on this cut off date we have some calculation in report.

-- How to create a date field with calender. which don't have any values in database (this field is not there in database) .

Thanks all

[Former Member]

Hi Neeraj,

you can refer the following link:

Thanks

Megha

[former_member207052]

Follow the steps:

1. Create a new query in the web-I report. Choose ANY object that is of the type date in result object and add the same object in the filter panel. (do not worry even if the required dates are not there in your table. this is just a placeholder.) - Figure 1
2. Create a variable to read the user response and store it for further use. Figure 2
3. Now you can use this cutoff date anywhere you want in the report
   1. The important point here is that since you are using the user response, it is no longer connect to any queries/data sources and so you can use if freely as a global variable across your report. (Figure 3)

To suppress  "No data to retrieve in query" warning, you can play around with selecting a dummy value.

[former_member207052]

Updated Cutoff date formula:

=ToDate(Left(UserResponse("pmEnter CutOff Date:");(Pos(UserResponse("pmEnter CutOff Date:");" "))-1);"MM/dd/yyyy")

[former_member195292]

Narashimman.. Good one. I like it your logic.