Is it possible to use a table's property (e.g., Created Date) within a query. I would like to use that date to format some form fields. For example, if the Created Date is 8/15/12, then I would set a form's field to 'Aug 12'. Thanks.
I've heard about the problems with the Modified Date in the sys object but I don't know of any issues with the Create Date. What's wrong with it?Create and Modified dates are NOT reliable. Alex almost gave you the correct solution. The column should default to Date() rather than Now() unless you really want a time component.