having a tad of trouble

[Naka]

im having a bit of trouble generating a field in one of my queries. i think its fairly simple, all i want to do is have the field in my query to show a date, that is just calculated by subtracting 5 days from the current day. i have something that looks like =Now()-5 but that doesnt work obviously. so im just asking whats the imput going to look like if you want to subtract 5 days from a date? oh and im using short dates for the date inputs

 

[rainman89]

dateadd("d", -5, Date())

 

[Brianwarnock]

Now()-5 works for me. It just returned 01/08/2007 19:41:53. Of corse if you don't want the time uase Date()-5

Brian