Year() function? Can you give me example.
Year() function? Can you give me example.
Just Google for it and perhaps add VBA as well.![]()
Please use # icon on toolbar when posting code snippets.
Cross Posting: https://www.excelguru.ca/content.php?184
Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
"access vba date functions"
https://support.microsoft.com/en-us/...6-a3c43f0ac99e
Although may be a little out of date. Functions flagged as not available in Access apps are working for me with Access 2020.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Understood. Year() function will do the thing.