rsb87 Posted May 2, 2005 Share Posted May 2, 2005 I'm curious if anybody knows what the difference is between the now function and the date function. Is there benefits to using one over the other? Thanks. Link to comment Share on other sites More sharing options...
comment Posted May 2, 2005 Share Posted May 2, 2005 There is no Now() function in Filemaker Pro 7. --- There is no Now() function in Filemaker Pro 4, either. Was there ever such function in 5 or 6? Link to comment Share on other sites More sharing options...
Ender Posted May 2, 2005 Share Posted May 2, 2005 No, there never was a Now() function. Could rsb87 mean the Today function? But then is rsb87's "Date" function the Date() function or the Get(CurrentDate) function? Link to comment Share on other sites More sharing options...
comment Posted May 2, 2005 Share Posted May 2, 2005 There never was a Now - sounds like a Barry Manilow song title. Link to comment Share on other sites More sharing options...
Ender Posted May 3, 2005 Share Posted May 3, 2005 Snap along: Oh no, there never was a Now, Doo doo, da doo-woa. Yesterday, there was a Today, Da doo, da doo-woa, So there must'a been a Now, Da doo, da doo-woa, Only then, it was "Today", Da doo, da Oh yea. Link to comment Share on other sites More sharing options...
FileMakin' Tom Posted May 3, 2005 Share Posted May 3, 2005 Golly. Maybe they ought to add a "Now" function. LOL Link to comment Share on other sites More sharing options...
comment Posted May 3, 2005 Share Posted May 3, 2005 When? Link to comment Share on other sites More sharing options...
Vaughan Posted May 3, 2005 Share Posted May 3, 2005 No no, not When; Now. Who's on first... lol Now sounds like a DOS or UNIX command. Link to comment Share on other sites More sharing options...
comment Posted May 3, 2005 Share Posted May 3, 2005 Now() is an Excel function. Who's a band. Link to comment Share on other sites More sharing options...
FileMakin' Tom Posted May 3, 2005 Share Posted May 3, 2005 Golly Comment - "Now" is actually "Then" the second after it was now. How could that be useful? Tom Link to comment Share on other sites More sharing options...
comment Posted May 3, 2005 Share Posted May 3, 2005 Ask not how. Ask when. But not now. When, do you ask? Exactly! Link to comment Share on other sites More sharing options...
rsb87 Posted May 4, 2005 Author Share Posted May 4, 2005 My appology, I switch environments all the time and so I got the names mixed up. Ender is correct, I'm wondering what the difference is between the Today() Function and the Date() function. Since he mentioned it, what is the difference between the Get(CurrentDate) function. I have just switched over to FMP7 from 6 so perhaps some of these are no longer valid. Any info would be greatly appreciated. Thanks, rsb87 Link to comment Share on other sites More sharing options...
Maarten Witberg Posted May 4, 2005 Share Posted May 4, 2005 Today is no longer available in v7. In v6, it can be used to generate the current date, just as Get(Currentdate) in v7 and Status(Currentdate) in v6. The Today function is considered obsolete by some, even in v6. Date(mm;dd;yyyy) can be used to generate any date from three number or calc fields (or hardcoded values). If you use Get(currentdate) in a calculation pay attention to storing settings, unstored will have the field updated, stored not. kjoe Link to comment Share on other sites More sharing options...
CobaltSky Posted May 4, 2005 Share Posted May 4, 2005 As kjoe has said, Today is obsolete. But even when it wasn't, its role was quite different from that of the Date( ) function (which is used to specify an explicitly given date in FileMaker's internal date format, for use in calculations etc). The reasons that the Today function had fallen out of favour over a number of years are: 1. It resulted (and depended on) a forced reevaluation of stored calculations in which it was used, at file open - and this could introduce a lengthy delay when the files were large (sometimes running to an hour or more). Most users found this unacceptable. 2. In a 24/7 multi-user solution, the Today function was not updated on the server or the client which the system clock/calendar ticked over, with the effect that it fell further behind the longer the solution was online. Not good. The alternative approach that many preferred in earlier versions of FileMaker, was to either: a) use an unstored calcualtion based on the Status(CurrentDate) function, or b) create a date field called CurrentDate (or similar) and set up the start-up script to check that the date in that field was current and update it if not (eg using a loop or a Replace procedure, depending on the requirements of the solution). In FileMaker 7, since as kjoe has said, the Today function has been dropped, the latter technqiues (and variants of them) are the order of the day. Note that the Get(CurrentDate) function is the v7 equivalent of v6's Status(CurrentDate) function. Link to comment Share on other sites More sharing options...
rsb87 Posted May 5, 2005 Author Share Posted May 5, 2005 Thanks for the Great information. Cheers! rsb87 Link to comment Share on other sites More sharing options...
Glorifindal Posted September 5, 2007 Share Posted September 5, 2007 Now() is an Excel function.Who's a band. No, Who is in China - he is the new leader see : http://www.youtube.com/watch?v=FuE621j50Z0 Glorifindal Link to comment Share on other sites More sharing options...
mfif Posted September 5, 2007 Share Posted September 5, 2007 Hu's in China. -- Edit: Sorry, Glorfindal, missed your post. Link to comment Share on other sites More sharing options...
comment Posted September 5, 2007 Share Posted September 5, 2007 Who is in China Now you tell me? Ah, the wonders of the Internet: tell a joke, get heckled two years later... Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.