i'm trying to retrieve data of the past 13 weeks as well as the last 6 mths from the present day. i know its possible for the number of days but if i have a field that displays [weeks], how do i achieve the last 13 weeks from the current week? same as for 6 mths.

Have you looked at the Help file for the DateAdd() function?

thank you!
i checked it out and tried to use that function but it only allows me to return a date 13 weeks/ 6 mths from the present date in a calculated field column. i'm unable to display the data associated with their dates from this duration.
i used dateadd("m", -6, Date()) to calculate the date i want to start from. am i suppose to put this somewhere else instead of in a new calculated field?
i have a field for [inputdate] and i want to call all the dates in this fieldfor the last 6 mths from the present date and display all the data associated with it.
Any help?

So sorry! i have figured out the dateadd fuction but it only shows the data starting from (eg the 9/11/01 onwards if the current date is today 3/11/01).
i would want to see the data from the whole month of sep onwards. is that possible?

Between Date() And DateAdd("m",-6,Date())

Rich, thank you for your reply.
i've tried that out but it still returns the same problem i experienced. the whole month is not showed, only from the exact date 6 months before date().
is there a way to do this?

thank you all!
i figured it out. by using >=DateSerial(Year(Date()),Month(Date()-6,1)), i could get all the data from the start month. http://www.access-programmers.co.uk/ubb/smile.gif
take care