Calculation field and Date field question

[lzeng]

Hi:

In my FileMaker Pro 5.5 database, I have a Date field named "A" and a calculation Field named "B" which is calculated by (int)((Today - A)/7). Now I'm generating a data entry form, the user shall type in a Date in "A", then I'll return a page with the calculated result in "B" field, how can I do it using CDML?

Thanks in advance!

Catty

[Vaughan]

First thing, replace the Today function with Status (CurrentDate). Todat only calculates when the database is first opened: if it's left running continuously on a server the Today function won't update.

To get the calculation to display, just put the [FMP-Field: B] code on the format file specified in the -format tag.

[ November 26, 2001: Message edited by: Vaughan ]