3 Replies Latest reply on May 20, 2011 7:09 PM by fredmckinnon

    Grouping by Date/Timestamp - Timestamp hinders grouping?

    fredmckinnon

      Title

      Grouping by Date/Timestamp - Timestamp hinders grouping?

      Post

      Hey Gang,

      Sorry for all the newbie posts ...
      When I setup our files, our "Date" field is setup to be a timestampe (Date/Time) that is automatically entered at creation.  This seemed to be a great idea, so that we could have our data and time entered automatically when creating a new record.

      Now, when I try to add a leading or trailing summary on the "Date" field, it isolates every single entry as unique, I presume, becuase of the timestamp.  So, instead of grouping all of the May 1 entries together ... it splits every single entry up ... except those that happen to have an identical, to-the-second timestamp (which of course, is none).

      Is there anyway I can fix this, but still have our date/time automatically entered?  I could add a new "timestamp" field that is auto-entered on creation, and change the "Date" field to be a "date" only, but still have it automatically entered, i Suppose?

      Thanks.