Hi,

using Sage 100 Standard ERP 2014

I am writing a VI job to import a Customers Sales Orders, the source file is a CSV file, Loading into SO_SalesOrderHeader

the field i am having trouble with is OrderDate

The date on the CSV file comes across as   

for the Order date i have it set as Date Mask 7 M/D/Y

and i substring the source for a length of 10

but the import gave me result of 12/6/2014

any help on correcting my VI job would be appreciated, I dont want to default it to todays date.