Previous days Date in Query

[Guest.Visitor]

Use the following function DATE(DAYS(CURRENT(DATE))-1) This will convert current date to a number of days value. We subtract 1 from that value to go back one day and then convert back to a date using the DATE function.

[gary.shipp@s3t.co.uk]

Is there a way to calculate yesterdays date (or thinking about it, any previous day) in Query? I can retrieve the current date, and subtract one from the day portion of that date, but then things get messy/impossible when you go back into a previous month/year. Thanks in anticipation

[gary.shipp@s3t.co.uk]

lol I've just spent two hours messing about with result fields and converting dates and fields into different formats - 14 result fields used in total! This looks a little simpler! Thanks a lot.