Can any one explain this. I have 3 columns, a date column, month and day columns. The month and day columns are calculated columns of the date column. DOB - Date/Time (Date only format) DOB_Month - calculated column - MONTH(DOB) DOB_Day - calculated column - DAY(DOB)
I entered a couple of records. Some of them work just fine. Some - the Month and Day calculations appear to be treating the DOB date as one day back. NOTE: all of these records were entered at the same time. If I edit a value in the list (ie: name), it saves out the record with the appropriate Month/Day values. Within 5 minutes, the list refreshes with the wrong values. Again --- ONLY A FEW RECORDS ... not all of them.