COGSBorders

 

Our date field for the bank is embedded within text. How do we accommodate this?

 

Use our Custom Date Import (CDI) feature located at 'Options', then 'Import tab'.

--Turn CDI 'On'

--Enter the date's first position (counting from the left) within the field.

 

The following example shows the embedded date of Dec 31, 2004 in position 6:

12345678901234567 (positions)

Date:12312004     (example line)

In addition, you would need to set the following settings, even though you might be within your local format:

--Select Format, (12312002, 2002/12/31, etc...)

--Select a separator, (slash, colon, hyphen, none)

 

Knowledge Base Article: KB2014

Treasury Software Corp. 1999 - 2005.  All rights reserved.

Can't find what you need? Contact us