Requirement
Default dynamic date parameter values 
Solution 
Use following predefined function to default date para,eters -
 {$SYSDATE()$}                            – current date
 {$FIRST_DAY_OF_MONTH()$} – first day of the current month
 {$LAST_DAY_OF_MONTH()$}  – last day of the current month
 {$FIRST_DAY_OF_YEAR)$}      – first day of the current year
 {$LAST_DAY_OF_YEAR)$}       – last day of the current year
*Dates are system date of the server on which BI Publisher is running.
Example 
 
 
No comments:
Post a Comment