Article Details
Id:16896
Product:finPOWER Connect
Type:NEW
Version:3.03.00
Opened:09/04/2020
Closed:09/04/2020
Released:01/05/2020
Job: J024082

HTML Widgets; DBCombo control; Better detection of Date values when binding to a collection

When binding a widget.UI.DBCombo control to a collection via the RefreshFromCollection method (e.g., on the Bank Entry wizard, Batch dropdown), any property in the collection that ended in the word "Date" was assumed to be a date value and therefore formatted as a date.

However, in certain situations, it is beneficial to format the date server-side (i.e., in the Widget's Script code).

In cases such as this, the value would have been displayed as "NaN/Nan/Nan" in finPOWER Connect Cloud.

The detection of value types has been enhanced to cater for both date and text values as can be seen in the following:

  • The "Batch" dropdown for the Bank Entry wizard (in both finPOWER Connect and finPOWER Connect Cloud)
    • This is actually a pre-formatted text value
  • The "Tax Period" dropdown on the parameter entry form for the "Tax Period Reconciliation" report in finPOWER Connect Cloud
    • The "Date From" and "Date To" columns are true dates