Pages

Recently Viewed

Saturday, December 31, 2022

How to default Date value in parameter


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