I am using microsoft date and time picker in my forms for users to populate date fields. Problem is I forgot to set the format to "short date" in the form. I did, however, set the input mask on the table to be short date.
Unfortunately, the input mask did not mask out the time portion of the long date. When the users choose a date from the calendar on the form, it adds the time. now when I try to do reporting, instead of having a 1 short date for each record, i have multiple date and times for the same day.
I'm not sure if I need to do a sweeping change of the format in the date fields, or if I can just adjust my excel pivot table somehow to look at each day's entry as a single date.
3/19/2007 - 1:00
3/19/2007 - 1:02
i need to be able to choose 3/19/2007 in my pivot table to determine which records have that date. instead it is giving me hundreds of choices for 3/19/2007 with different times throughout the day.
Anyone know how i can fix this?