Understanding "as of", "as at", and "as from"
I'd appreciate your assistance in helping me particularly understand how to use the phrase "as of" properly.
What is the proper interpretation of the following sentence?
"I need you to get me all transactions as of January 23rd"
- That I need all transactions from the beginning of time (so to speak) till January 23rd, or
- That I need all transactions from January 23rd to now?
Would "as at" be more appropriate to express (1)?
Would "as from" be more appropriate to express (2)?
Solution 1:
Joel is mistaken when he says that as of means "up to and including a point of time," although it is often used to mean so.
As of designates the point in time from which something occurs. So as of some point would mean from the date specified onward.
However, his answering of the best way to say each phrase is spot on.
One may use either until or up to to mean the time before which something occurs (remaining ambiguous about whether the date is inclusive or not).
And since is a fine choice.
So far as as from--this is a perfectly good expression in English. It has roughly the same connotation as as of except that it often holds the time before and the time after in contrast.
Solution 2:
As OF implies everything up to and including a particular point in time.
As AT is similar to as of, and could be used synonymously. As at has a connotation of a snapshot. You might say transactions as of but balance as at.
As FROM is not an idiom in English as far as I have ever heard.
In order to be more clear, you could use different language altogether:
I need all transactions up to and including January 23rd.
I need all transactions since January 23rd.