In Rollbase 2.0.0.3 both date and date-time fields showed the "2014-01-13 00:00:00.000" format in the results from selectQuery() SOAP API call. In Rollbase 2.1.0.0 both date and date-time fields show the "Mon Jan 13 00:00:00 EST 2014". So the formats are consistent across the two data types, but the format changed between Rollbase versions. As a result, the code that we are using to convert the dates in the results into strings that sort correctly and can be used for date comparisons in ABL no longer work correctly
Is the date format of selectQuery() results something we can configure? If not, is there a format that we can rely on staying the same going forward?
We have observed this issue already , and it is fixed . It will be available in next hotfix release.
You did not fully explain what is fixed. Will the hot fix return to the 2.0.0.3 behavior?=
Yes, it will be reverted to 2.0.0.3 behavior . The fix is that , selectQuery SOAP API Call for both date and date-time fields will now return the value in this format '2014-01-13 00:00:00.000' instead of "Mon Jan 13 00:00:00 EST 2014".
Hmm strange in 3.2.5 it is like Mon Jan 13 00:00:00 EST 2014