status (currentdate) 
Author Message
 status (currentdate)
Do I have this right? when I define a field as Status(CurrentDate) doesn't
that mean that it will update the field to today's date? If not, how can I
do that, if so, why isn't it working?

thanks

Jessica



Tue, 11 Nov 2003 06:49:50 GMT
 status (currentdate)

Yes, you have it right. Try defining it as unstored.

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> Do I have this right? when I define a field as Status(CurrentDate) doesn't
> that mean that it will update the field to today's date? If not, how can I
> do that, if so, why isn't it working?

> thanks

> Jessica



Tue, 11 Nov 2003 07:04:12 GMT
 status (currentdate)
You can use the "Today" function in your calculation.

Diego

Quote:

> Do I have this right? when I define a field as Status(CurrentDate) doesn't
> that mean that it will update the field to today's date? If not, how can I
> do that, if so, why isn't it working?

> thanks

> Jessica



Tue, 11 Nov 2003 17:39:16 GMT
 status (currentdate)
Hi Jessica and Diego

As a general rule, Status (Current Date) is preferable to the Today
function.  All records in any database that contains the Today function
are updated the first time the database is opened each day all at once.
For large databases, this causes a considerable delay when opening the
file.  In databases that are intended to be kept open 24/7, it means the
database must be closed then opened at least once a day.   Status (Current
Date) does not have these limitations.

--
Bridget Eley


Quote:

> You can use the "Today" function in your calculation.

> Diego


> > Do I have this right? when I define a field as Status(CurrentDate) doesn't
> > that mean that it will update the field to today's date? If not, how can I
> > do that, if so, why isn't it working?

> > thanks

> > Jessica



Tue, 11 Nov 2003 18:54:33 GMT
 status (currentdate)
Hi Bridget Eley

You are rigth, but if I use today function in a script I haven't this problem.

Diego

Quote:

> Hi Jessica and Diego

> As a general rule, Status (Current Date) is preferable to the Today
> function.  All records in any database that contains the Today function
> are updated the first time the database is opened each day all at once.
> For large databases, this causes a considerable delay when opening the
> file.  In databases that are intended to be kept open 24/7, it means the
> database must be closed then opened at least once a day.   Status (Current
> Date) does not have these limitations.

> --
> Bridget Eley



> > You can use the "Today" function in your calculation.

> > Diego


> > > Do I have this right? when I define a field as Status(CurrentDate) doesn't
> > > that mean that it will update the field to today's date? If not, how can I
> > > do that, if so, why isn't it working?

> > > thanks

> > > Jessica



Tue, 11 Nov 2003 19:59:58 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. status(currentDate) not updating

2. Today or Status(CurrentDate)

3. Today vs Status(Currentdate)

4. Today vs. Status(CurrentDate)

5. status (currentdate) won't update to current date

6. today vs. Status ( CurrentDate )

7. Question for the Pro's: Problem with Status(CurrentDate) Funtion?????

8. How to add to CurrentDate

9. Exporting data with DTS and including the currentdate in the excel file name

10. comparing currentdate tag with date fields

11. Y2K w/ [FMP-CurrentDate] ?!

12. CDML [FMP-CurrentDate] not Y2k compliant?


 
Powered by phpBB® Forum Software