![]() | |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
I have calculation which includes current day: Birthday - Get ( Current Day ) gives me number of days. However, this culculations stands, when current date changes. How to set up date function to change automatically with my system date. Thanx, Tomislav |
#3
| |||
| |||
|
|
In article <eme5h7$f8q$1 (AT) ss408 (DOT) t-com.hr>, tomislav <tomislav (AT) htnet (DOT) hr wrote: I have calculation which includes current day: Birthday - Get ( Current Day ) gives me number of days. However, this culculations stands, when current date changes. How to set up date function to change automatically with my system date. Thanx, Tomislav Go into the Define Fields window and double-click that field. At the bottom of the 'enter calculation' window click on the "Storage Options" button. In the new window that appears turn on the "Do not store calculation results" option. Click OK / Done to close all the windows. Since it's now not stored, the calculation will be re-calculated every time it is displayed / used. Helpful Harry Hopefully helping harassed humans happily handle handiwork hardships ;o) Thank you. |
#4
| |||
| |||
|
|
Helpful Harry wrote: In article <eme5h7$f8q$1 (AT) ss408 (DOT) t-com.hr>, tomislav <tomislav (AT) htnet (DOT) hr wrote: I have calculation which includes current day: Birthday - Get ( Current Day ) gives me number of days. However, this culculations stands, when current date changes. How to set up date function to change automatically with my system date. Thanx, Tomislav Go into the Define Fields window and double-click that field. At the bottom of the 'enter calculation' window click on the "Storage Options" button. In the new window that appears turn on the "Do not store calculation results" option. Click OK / Done to close all the windows. Since it's now not stored, the calculation will be re-calculated every time it is displayed / used. Thank you. |
\
#5
| |||
| |||
|
|
In article <emg45m$fik$1 (AT) ss408 (DOT) t-com.hr>, tomislav <tomislav (AT) htnet (DOT) hr wrote: Helpful Harry wrote: In article <eme5h7$f8q$1 (AT) ss408 (DOT) t-com.hr>, tomislav <tomislav (AT) htnet (DOT) hr wrote: I have calculation which includes current day: Birthday - Get ( Current Day ) gives me number of days. However, this culculations stands, when current date changes. How to set up date function to change automatically with my system date. Thanx, Tomislav Go into the Define Fields window and double-click that field. At the bottom of the 'enter calculation' window click on the "Storage Options" button. In the new window that appears turn on the "Do not store calculation results" option. Click OK / Done to close all the windows. Since it's now not stored, the calculation will be re-calculated every time it is displayed / used. Thank you. One thing to be noted though, with lots of records and / or a slow computer this field can take a while to update itself. About 10 years ago I had a database that used a similar calculation to work out an athlete's age as of "today". Every morning when I first opened the database it would take around 20 minutes to run through the re-calculation process. Of course, computers are much faster these days, but people's ability to wait has also diminshed accordingly - people complain about a new iMac taking 30 seconds to boot up. \Helpful Harry Hopefully helping harassed humans happily handle handiwork hardships ;o) |
![]() |
| Thread Tools | |
| Display Modes | |
| |