OTBI prompt set default values for date between first and last day of current year
I know that I can set a default for a prompt as todays date using the SQL expression
select current_date from "Workforce Management - Worker Assignment Real Time"
I think the following formula will convert todays date into the first day of the current year, although the syntax may need to be tweaked:
and that a formula like this will get the last day of the year:
I tried combining the expressions but it was not successful. Where am I going wrong? It must be possible to be able to have dynamic date prompts to enable reports to be scheduled.