how i can express today date in calculated field in table
how i can express today date in calculated field in table
Can't. Why would you need to have field that is just the current date?
Last edited by June7; 06-18-2019 at 05:01 AM.
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.
you can set the default value to date() or now() - which will automatically populate when the record is created - which may meet your needs.
Shouldn't use calculated FIELDS in tables!
Calculations are better done in queries.
Also should stay away from Look up FIELDS and Multi-value FIELDS in tables.