Article Details
Id:10293
Product:finPOWER Connect
Type:NEW
Version:1.06.00
Opened:04/05/2012
Closed:10/07/2012
Released:01/08/2012
Job: J009542

Date text conversions; removed some logic to do with intelligent date conversions

When converting a "text" date to an "date" value finPOWER Connect applies several pieces of logic, eg it looks for a month entered as text as in "May".

One of these pieces of logic is to look for a four digit value and assume that is the year.

However, this was causing complications and clashes with day/month/year ordering within the text.

Therefore, this piece of logic has been removed. This means dates may now return Nothing rather than an incorrect date.

For example, if you entered "2/5/2012", and specified that the date is in "YMD" order then this should return Nothing - but it was returning "5 February 2012". This is because the 2012 is determined as the year, leaving the Month and Day to be found in that order. However, this date could be the "2 May 2012" - and in Australia and New Zealand would typically be this.

Note, this change has been implemented for bank imports as these files define the day/month/year order but sometimes the file was not in the expected order.