Could it not also be "Where were you on Wednesday"? Or is this never interpreted in the past tense?

This sentence could be past/present tense.
It depends on the context.
Since there is no context here, both English translations (are/were) should be acceptable.