Access Date Calculation Formula

[Harold_W490]

This Query Formula Works Well

DC: DateDiff("yyyy",[DominionServiceDate],[Expiry-Date]+1)

I want to Change change it to give me an answer based on today's date, not the Expiry Date.

TY

[#2]

Hi,

Use Date() instead of [Expiry-Date].

Servus
Karl
****************
Access DevCon - online conference April 18+19
Access Forever
Access News
Access-Entwickler-Konferenz AEK