Dashboard Prompt Default to LAST_DAY(sysdate)

Question

Is there anyway to default a dashboard prompt to the last day of the current month?

I tried using SQL RESULTS as "select last_day(sysdate) from dual" but this does not work.  The prompt defaults to "All Column Values".

The value needs to be a date in the format MM/DD/YYYY.

I want to avoid adding a variable to the repository.

Any help would be appreciated.

Raymond

asim cholas · Answer

Best way is to use the time dimension and populate it in a field.but if there is no other go use substring function and concatenate to make desired format

Gianni Ceresa · Answer

Almost there, the formula isn't fully right but it's the "arithmetic of dates" approach suggested above.

The OP will easily be able to get the right one.

asim cholas · Answer

try below formula (untested)

Select timestampadd(sql_tsi_day,-dayofmonth(CURRENT_DATE),timestampadd(sql_tsi_month,1,CURRENT_DATE)) FROM "YOUR SUBJECT AREA"