NEW3.03.00 · Released 1 May 2020

NEWfinPOWER Connect

Released in

3.03.00

1 May 2020

1. Opened9 Apr
2. Closed9 Apr
3. Released1 May

Article 16896 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