Either can be correct, depending on the idea you want to express.
”On that day, which was a Tuesday, my sister and I went to the store together.”
”In that day, before antibiotics had been discovered, many people died from diseases which are now curable.”
”On that day” refers to one...