Explanation

Direct speech: He said to me, "Why are you sad today?"

Indirect speech rules:

Said to → changes to asked (since it's a question).

Are → was (present to past).

Today → that day (change in time expression).

He asked me why I was so sad that day.