Regional settings / Date error (3 replies)
Frans, to answer:
a. Yes IMan is affected by regional settings. The user under which the Scheduler & Data services runs (or the System Default if running under Local System) dictates how dates will be interpreted.
b. In your case the date is yyyy-MM-dd which is not convertible to a US date (mm/dd/yyyy).
To remedy you must convert the yyyy-MM-dd value to the US one.
You can try the following function (replacing DateField with the actual field containing the value):
NumberToDate(Replace(%DateField, "-", ""))
NumberToDate(Replace(%DateField, "-", ""))
Seeing that I was working with SQL as a data source, the solution was to use CONVERT(DATE, XXX) for the dates, and for the optional field I used CONVERT(VARCHAR(10), XXX, 112) seeing that optional fields are stored as text, even if they are dates.
Closed due to inactivity.
I am working on a client that has US regional settings (eg. mm/dd/yyyy), and I’m getting this error:
Accpac API Error - Failed to convert string '2016-05-01' to an internal Date representation.
Similar question: Does the regional setting affect IMAN?