Forum Post: selectQuery() date and datetime fields format appear to have changed between...

[mopfer]

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?

Continue reading...