Subtracting fields in the Where Clause

Hi,

I'm trying to familiarize myself with Torque and so far I've been having some
trouble porting SQL statements to Criteria. Currently, what I am attempting to
do is to get the following query (originally MySQL 4.0):

SELECT user_id
FROM subscribers s
WHERE to_days(s.end_of_subscription_date) - to_days(SYSDATE()) = 5

The query extracts a list of users whose subscriptions to a service will end in
5 days. How can I add a Criterion with a mathematical expression? Is it
possible or do I have to use BasePeer.executeQuery()?

Regards
Ruy


                
__________________________________ 
Do you Yahoo!? 
Meet the all-new My Yahoo! - Try it today! 
http://my.yahoo.com