Access Date Calculation Formula

Question

This Query Formula Works WellDC: 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

karl_donaubauer · Answer

Hi,
&nbsp;
Use Date() instead of [Expiry-Date].
&nbsp;
ServusKarl****************Access DevCon - online conference April 18+19Access ForeverAccess NewsAccess-Entwickler-Konferenz AEK
&nbsp;

Forum Discussion

Access Date Calculation Formula

Share

Resources