Forum Discussion
Harold_W490
Mar 14, 2024Copper Contributor
Access Date Calculation Formula
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
Hi,
Use Date() instead of [Expiry-Date].
Servus
Karl
****************
Access DevCon - online conference April 18+19
Access Forever
Access News
Access-Entwickler-Konferenz AEK