With the new operators AFTER, SINCE, BEFORE and DURING you can define points or periods of time by absolute - means: you use either the whole date or just parts of it. On the other side DURING LAST allows you to define a period wich is relative to now: it begins in the past and ends always now - its length is always the same.

What i miss is opportunity to create a period wich also stands in relation to now but has a different logic than that defined by DURING LAST. The best is to give some examples:

We have now 16. May 2008. A period "today" would give back all that is after 16. May 2000 00:00:00, a period "yesterday" gives back all that happened at 15. may 2008 from 00:00:00 till 23:59:59 (whereas DURING LAST day return the last 24 hours), a period "last month" means everything from april (no matter if we have 16. May, beginning or end of may), and so on. I hope it is clear what i mean and what the difference is to "DURING LAST".

I would appreciate any solution but would be happy having opportunity to combine AFTER, SINCE, BEFORE, DURING operators with some time units expressions that allow to define what i described above. Examples with preconceived names for time units:
%last_played% DURING DAY AGO = yesterday
%last_played% DURING 2 MONTHS AGO = march
%last_played% AFTER DAY AGO = today