www.softrak.com
Adagio Accounting Software (homepage) Softrak Technical Support Forums
Topic Options
#7122 - 06/26/06 03:02 PM Importing a db3 file into Adagio Ledger
Anonymous
Unregistered


Using the import function in Adagio ledger to import monthly financial tranactions from our in house sysyem into Agagio ledger received the following error on 2 of the fields with date values.

"Invalid Date '05/31/2006' in field called 'Fiscal Date" in record 1" Receive same error for field Transaction Date. Receive these errors for all records.

Spoke with our database guy here and he sugguested it may be the windows system date. I tried every date combo I could and received the eooror each time.

If I open the database this is the date format in each of the 2 fields that are failing: 05/31/2006



Commonwealth Insurance Co.
Jeffrey Marshall

Top
#7123 - 06/26/06 03:12 PM Re: Importing a db3 file into Adagio Ledger
Ralph Allan Offline
Adagio Virtuoso

Registered: 06/02/04
Posts: 667
Loc: Prince George BC
Check under Start / Control Panel / Regional and language options / Short date.

It should be mm/dd/yyyy
_________________________
Ralph Allan
Business Computer Centre
Prince George BC Canada

Top
#7124 - 06/26/06 03:34 PM Re: Importing a db3 file into Adagio Ledger
Anonymous
Unregistered


Running import now and is working so far. Will post further when completed.

Top
#7125 - 06/29/06 09:05 AM Re: Importing a db3 file into Adagio Ledger
Anonymous
Unregistered


The import worked correctly. Thank you for your help. It has lead to a new question about a report that I'll post in a new question.

Top
#7126 - 08/22/06 11:18 AM Re: Importing a db3 file into Adagio Ledger
Anonymous
Unregistered


I am trying to import a csv file and get the same error. I have tried to set the system date as detailed and I still get the "Invalid Date '05/31/2006' in field called 'Fiscal Date" in record 1" I do not get an error on the trasnaction date however. It is set to ascii YYYYMMDD format.

I had no issue with this previously but recently I installed a Ledger patch.

Sheldon Dyck

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 2 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Top Posters This Week (Users)
SusanTennier 5
JBjarnason 3
Kristin 3
pnadjiwon 2
kruth 2
Forum Stats
1429 Members
5 Forums
8859 Topics
40400 Posts

Max Online: 55 @ 12/31/13 05:47 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30