kjanisse Posted April 19, 2001 Share Posted April 19, 2001 Hello all, Everything I have read seems to indicate that in order to get the Today function to update itself, you must close the DBs on FMServer, then launch them in FileMaker, close them, then open them in FMServer again. As a test, I created a simple DB with a Calc field set to "Today". When I just close down the server and relaunch it again, the Today value gets updated (without having to open it in a regular verson of FM). Is this middle step of using a regular version of FM necessary?? Thanks... Link to comment Share on other sites More sharing options...
markpro Posted April 19, 2001 Share Posted April 19, 2001 if the today function is being used to set a global field, that may be your problem as changes are only saved at the host machine to global fields. Link to comment Share on other sites More sharing options...
Kurt Knippel Posted April 20, 2001 Share Posted April 20, 2001 quote: Originally posted by KenJ: Hello all, Everything I have read seems to indicate that in order to get the Today function to update itself, you must close the DBs on FMServer, then launch them in FileMaker, close them, then open them in FMServer again. As a test, I created a simple DB with a Calc field set to "Today". When I just close down the server and relaunch it again, the Today value gets updated (without having to open it in a regular verson of FM). Is this middle step of using a regular version of FM necessary?? I thought so, but perhaps Filemaker did something in the new version of Server which makes this unnecessary. We are running FMP 5 and have not observered this. We still need to open the files in a copy of FMP Client. Perhaps a client is being opened somewhere else and you are not seeing it. Link to comment Share on other sites More sharing options...
kjanisse Posted April 20, 2001 Author Share Posted April 20, 2001 Hi again, I just verified that the Today function does indeed update by just closing FM Server and relaunching it. I created a test DB with 3 fields: Calc_Today: calculation is "Today" EnterableDate: this is just a date field you can enter a date into Calc_Difference: calculation is "Today - EnterableDate" When I close then relaunch FM Server everything gets updated... Link to comment Share on other sites More sharing options...
Ocean West Posted April 20, 2001 Share Posted April 20, 2001 have you tried changing the system clock in between restarts? Link to comment Share on other sites More sharing options...
Ocean West Posted April 20, 2001 Share Posted April 20, 2001 have you tried changing the system clock in between restarts? Link to comment Share on other sites More sharing options...
DykstrL Posted April 20, 2001 Share Posted April 20, 2001 If you are using FMP 5 replace the TODAY functions with: Status(CurrentDate) Problem solved - there's no recalculation required. Link to comment Share on other sites More sharing options...
Ocean West Posted April 21, 2001 Share Posted April 21, 2001 In order to really test your theory you need LOTS of records and some complex math against the date, in most cases the reason why you don't see the update today is because it happens so fast on only a few records. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8414 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now