Manipulating Date Parameters using {$SYSDATE()$} in Fusion HCM Reports

While working on BI and OTBI, we will come across various situation when we will need to manipulate Date parameter. This can be done using {$SYSDATE()$}.

{$SYSDATE()$}: This gives the current system date. 

{$SYSDATE()$ - 1$}: Current date minus 1 day in past

{$SYSDATE()$ +7$}: Current Date plus 7 days in future

{$FIRST_DAY_OF_MONTH()$}: First day of the month

{$LAST_DAY_OF_MONTH()$}: Last day of the month

{$FIRST_DAY_OF_YEAR)$}: First day of the year

{$LAST_DAY_OF_YEAR)$}: Last day of the year

For example: {$SYSDATE()$} = March 3rd, 2021

{$SYSDATE()$ - 1$}: March 2nd, 2021

{$SYSDATE()$ +7$}: March 10th, 2021

{$FIRST_DAY_OF_MONTH()$}: March 1st, 2021

{$LAST_DAY_OF_MONTH()$}: March 31st, 2021

{$FIRST_DAY_OF_YEAR)$}: January 1st, 2021

{$LAST_DAY_OF_YEAR)$}: December 31st, 2021

Find below the link on how to add dynamic parameters in reports

https://fusionhcmblog.blogspot.com/2020/05/how-to-add-dynamic-parameters-while.html