How do I default the current year in a date parameter in a BI Publisher data model?
You can use the same sysdate function {$SYSDATE ()$}
that's used to
default a date in the parameter and specify the date format string as
yyyy
.
Here are the settings:
Attribute Name | Attribute Value |
---|---|
Name | p_year |
Data Type | Date |
Default Value | {$SYSDATE()$} |
Parameter Type | Date |
Display Label | Enter Year (YYYY Format) |
Text Field Size | 4 |
Options (Ignore User Timezone) | Checked |
Date Format String | yyyy |