Yes in the prompt the field has to be a DATE or DATETIME to display the calendar. My suggestion was to edit the filter in the analysis, not the prompt. However I see there is actually a patch that you could apply. It would spare you from editing all your dashboards. Have a look for patch 23211224 on My Oracle Support.

Hi @3520535, I guess these two dates are setting up presentation variables that you use in your analysis. In that case the PVs will be string and while OBIEE can sometimes convert it to date, it's always a good practice to do an explicit conversion. That way even if the user changes his/her date formatting, it will still…