I have a non-standard date format. How do I use it?

ACH Universal > Frequently Asked Questions (FAQ) > I have a non-standard date format. How do I use it?

Q: I have a non-standard date format.  How do I use it in ACH Universal?

A: A non-standard format is a format which isn't supported by your Windows (Control Panel, Regional Settings) Settings.

A date format of 31/12/2002 is non-standard in the United States, but is standard in the United Kingdom.

To import non-standard formats, use a Custom Date Import (CDI).

From the main menu, select File, then Options, then General. 

 
In the Import tab, set  "Custom Date Import (CDI) G/L:" to On

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

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

If the date is embedded within another field, see My date field is embedded within text.              

Page url: http://www.treasurysoftware.com/Help_ACH_Universal/index.html?faq_nonstandarddate.htm