I have an auto-enter date field. It's just the creation date. I'd like it to be a creation timestamp from now on. Can I simply change the data type? When I update clients in the future, they will of course have dates in this field, but moving forward the creation would be a timestamp.
Is this a problem? I've been playing around with it, and everything seems to work fine. When I view a timestamp field with a date via GetAsNumber, it just fills out the number with 0's. Everything (sorts, etc...) seem to 'just work'. I'd rather not have to change existing data to timestamps by adding some arbitrary time (i.e. 12:00:00 AM or whatever).