To-do table date problem

[tbac]

In MS Access I have a 'to-do' table populated with tasks that need to be done throughout the year, and a check box for 'Done'. Right now I use a query that uses julian dates to refer to tasks that have not been done yet in the past 30 days to dates over the next 30 days. In the query I have in 'criteria' for the julian date, '>DatePart("y",Now()-30)' to show julian dates for the past 30 days. That works fine once you get into the year, but for example, on January 1st, when julian date is '1', it does not show tasks from December. How should I configure it to be able to show past dates when in January?

 

[PHV]

There is no year in your 'to-do' table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886