NEW3.03.00 · Released 1 May 2020

Breaking Change

NEWfinPOWER Connect

Released in

3.03.00

1 May 2020

1. Opened12 Mar
2. Closed12 Mar
3. Released1 May

Article 16805 Job J023899

Date function expressions now use the Database Date and can be used without parameters

The expression evaluation within finPOWER Connect accepts date-related functions.

The following functions returned the current local Date and Time as per the Windows PC running finPOWER Connect:

• Date()
• Now()

These have been updated to use the Database Date and Time as per the database's configured Time Zone.

The following functions date functions which can be used in expressions such as calculating a default parameter for a report can now be supplied with no parameters and will assume the current database date:

• BOM() - Beginning of Month
• EOM() - End of Month
• EOMP() - End of Previous Month

Previously, you had to supply a date, e.g., "=EOM(=NOW())