using todays date in calculated row (1 Viewer)
- Thread starter kobiashi
- Start date
thanks for the reply
i tried to use that in the formula but it didnt work
heres what i tried
Code:
LastDone - Date()
- Local time
- Today, 16:26
- Joined
- Feb 28, 2001
- Messages
- 27,138
You have your answer, but you should note that putting calculations in a table is just NOT a good idea. Do calculations in a query. Also, do you realize that every time you open the table, you recompute the row? If the goal was to compute an elapsed time from one event to another, your computed row is NOT static.
This would normally give you a negative value if LastDone is a date PRIOR to today. The calculation would normally be
Code:
Date() - LastDone
June7
AWF VIP
- Local time
- Today, 13:26
- Joined
- Mar 9, 2014
- Messages
- 5,465
That statement is rather confusing.
If you want each record to pull value from another record - HAS to be done in query with nested subquery. Review http://allenbrowne.com/subquery-01.html#AnotherRecord
Last edited:
- Local time
- Today, 16:26
- Joined
- Feb 28, 2001
- Messages
- 27,138
Good catch, June!
