I think it would depend on the question. For instance, you might have something that you're concerned about that's coming up in the future, so you might ask something like, "How does the future event affect me in the present?" In that case, the Cause cards would be the future, and the Effect cards would represent the present.
Or you could ask, "Am worrying too much about the future?" The Cause cards would represent the future, and the Effect cards would be the past.
For most people, in most situations, the Cause and Effect would be past/present (Cause) and future (Effect). I just wanted to point out that it doesn't necessarily have to be that way.