Article Details
Id:16805
Product:finPOWER Connect
Type:NEW
Version:3.03.00
Opened:12/03/2020
Closed:12/03/2020
Released:01/05/2020
Job: J023899
Breaking Change

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())