So the now() keep change with the time and date. for example. Yesterday I made the ticket but it now has todays date and time instead of yesterdays. So it changes with it. Is there away to make it not do that?
QuickBase has built in automatic fields for the [Date Created] and [Date Modified]. These are actually date/time field types. It sounds like you can use the [Date Created] field to get the time your ticket was Created.