how i can express today date in calculated field in table
Advanced Beginner
Windows 7 32bit 
Access 2007
how i can express today date in calculated field in table
VIP
Windows 10 Access 2010 32bit
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.
VIP
Windows 10 Access 2010 32bit
you can set the default value to date() or now() - which will automatically populate when the record is created - which may meet your needs.
Master of Nothing
Windows 7 32bit Access 2010 32bit
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.
condition if date is earlier or later than today calculated column
Calculated Field: Today() - [DOS]
Posting Permissions
Reply With Quote