Date Field

[Eddie Mason]

Hi All,

I want to calculate a date which, is exactly 1 year previous to a user-entered date. Eg 20/04/03 entered then I want 20/04/02 calculated.

I've tried using:

[fldPastDate] = [fldCurrentDate] - 365

But this does not always bring up the same date for the previous year, occasionally its1 day out.

Is there a simple way to calculate this date?

Regards

Eddie

 

[ColinEssex]

DateAdd("yyyy", -1, [YourField])

Col

 

[Eddie Mason]

Hi Col,

Thanks for your help I've now got it up and running.

Regards

Eddie