How to add current date on a field?

[riveranrx]

Hi, I used FM 6 and there was an option in the calculation field that says "today". That was very useful to display the actual date and to calculate for example days since last exam, etc.

How can I do this in FM7. There is no "Today" option!

Is there another way?

Thanks

Rodrigo, from Chile.

[TaiChi56]

There is an Insert current date option under insert. Maybe that will help you do what you want.

Hi, I used FM 6 and there was an option in the calculation field that says "today". That was very useful to display the actual date and to calculate for example days since last exam, etc.

How can I do this in FM7. There is no "Today" option!

Is there another way?

Thanks

Rodrigo, from Chile.

[Lee Smith]

and a script step too.

[riveranrx]

I have tried with get current date, but it is no dynamic. Its stay in date that the field is modified and I can t use it for dynamic calculation.

I have also tried with scrips but the only modified field is the current record in use and not all records.

Thanks!

[Lee Smith]

You would need to use a loop Script in combination with the Insert or set field function.

Or

You can use the Replace at the Browser level (Go to Menu - Records - Replace - Replace with calculated result, this will change every record in your found set.

why not tell us what you have now, and what you want to happen. i.e.,

Will this be only a field for the date, or is there other Text in the field too.

Lee

[comment]

Try the Get(CurrentDate) function.

[riveranrx]

I work in an hospital and I want to calculate how many days has passed since a patient was admited to the hospital or since a surgery was done, etc.

There is a list of actual patients and summary of these items. So I need the current date to be actualized each day to keep these up to date.

Thanks!

[Lee Smith]

you need to use the function mentioned by comment in the calculation. Be sure that the calculation is "Unstored"

I Keep reading what you want a little differently, Try this calculation and see if it does what you want.

Get( CurrentDate) - YourDateFiel

result will be number

Lee

Edited January 10, 2006 by Guest
tried to clarify

[riveranrx]

Thanks to all of you I get to a solution.

I made a Script that contained record replace and then a calculation with get(current date). That works great!

Thank to all!

Rodrigo