Good Morning,
I am building a Windows Universal App using Azure Mobile
Services and implementing offline data using sqlite as a local database.
Everything is working great. Thank you for making this available. When I
Sync the data everything works well except for the created date column which
has a format of "2/20/2015 2:13:26 AM +00:00". When I attempt to view the
data in the sqlite table I receive an error stating that
"System.FormatException: String was not recognized as a valid DateTime". We
have no control over how azure stores the date. As a work around I have
also been storing the date as a string in a text field but this makes trying
to sort by date impossible. I would like to sort by the created date but
cannot if sqlite sees it as an invalid date.
Any help you can offer would be greatly appreciated.
Thank you
David
