I'm trying to post a date (yyyymmdd) into a SQL table that uses a date type field. Every time I do so with Query Analyzer in the same format, it works fine, but in Delphi using...
FieldByName('Date').asstring := '20050305'
I receive 20050305 is not a valid date.
So then I figured I would try to use
FieldByName('Date').asdatetime := strtodate('20050305')
And that fails with the same error. I also tried to set ShortDateFormat to = 'yyyymmdd' but with no luck.