>how do you get the create date and modify date for a record?

At least in SQL7 I don't think there is such facility. You would have to roll your own fields and update them with INSERT and UPDATE triggers.