Strange DateTime conversion issues

  • Using YYYY-MM-DD solved my issue with Between. FWIW I was using AutoQuery Data, not RDBMS. Is Between safe to use with In Memory Datasets?

  • Regarding the timezone offset issue, the results were from my developer workstation, so it’s just one box in a single call. Changing SkipDateTimeConversion to false doesn’t change the result. The only other thing unique to my config would be that I am converting the overall object type( based on Show POCO names instead of DataMember names). Any other ideas?