minus 100 days

[Chimp8471]

How would i get a query to run with a date range of today - 100 days,

i tried

=now()-100

but that didnt seem to work

 

[ColinEssex]

If you are looking for the ONE date that is today - 100 then its

Date() - 100

if you want all dates up to 100 days ago then use

>Date() - 100

Col

 

[mission2java_78]

If you are looking for the ONE date that is today - 100 then its

Date() - 100

if you want all dates up to 100 days ago then use

>Date() - 100

Col

Dont use the Date and Now functions when trying to add / subtract days from a given date. There are various times where the results are undefined and return some *weird* results. That is why there is a DateAdd() function. If you want to subtract hours from a date simply use a negative number as an argument to the function.

 

[ColinEssex]

Thanks Java! - thats very true - I posted my reply without thinking it through too much, put it down to monday morning fatigue

Col