Help with an Action Item SQL Query

Yes, FactorySQL is certainly going to cast it to a normal date in order to work with it, and is then going to write it back as such. However, the database driver should be able to truncate it without a problem…

I just did a quick test and was able to write to a SmallDate column from an action item without a problem… is it possible that one of your values is in fact out of range (that is, you’ve got the days mixed up with the months or something?)

It’s probably something simple…

Regards,