Complete the following steps to round values date/time values in a column.
|Day||The midpoint for any day is noon (12:00 PM).|
|Week||The midpoint for any week is noon (12:00 PM) on the 4th day of that week. For example, if your system settings specify Sunday as the first day of the week. Then, the midpoint for the week is noon on Wednesday.|
|Month||The midpoint for any month is midnight (12:00 AM) on the beginning of the 16th day of the month, regardless of how many days are in the particular month. For example, the midpoint for February each year is midnight on the 16th. Dates and times for the 15th and earlier in the month are rounded down. Dates and times for the 16th and later in the month are rounded up.|
|Quarter||The midpoint for each of the 4 quarters of the year is the midpoint for the middle month of that quarter:
|Year||The midpoint for each year is midnight (12:00 AM), the start of the day July 1. Dates and times for June 30 and earlier in the year are rounded down. Dates and times for July 1 and later in the year are rounded up.|