Hello,
I could not find a command that delivers me the creation date of an record.
Under define Data base --> create record --> options for fields there is e.g
Date, account name..., provided,
but I could't find any command to fetch these data for using in a script.

Using FM7 pro

regards
Walter

You are correct that there is no Get(CreationDate) function, or similar
functions for the other creation and modification particulars.

You need to have a field that auto-enters (and thus stores) the creation
date (or better, the creation TimeStamp, because it includes both date and
time). I also usually include a modification field as well. Then you
reference this field in the future.

If you do not create fields for storing these values, they simply are not
saved.

Bill

"walhol" <hollerwal (AT) aol (DOT) de> wrote

Yes I know Get (creationDate), but I use the German Version. Hole(??????)
Walter
"Bill Marriott" <wjm (AT) wjm (DOT) org> wrote

What I am saying is there is no Get() or Hole() function for what you want.
You MUST autoenter the value into a field, and reference that field in later
calculations.

"walhol" <hollerwal (AT) aol (DOT) de> wrote

In article <dnbpbu$k1t$1 (AT) news (DOT) mch.sbs.de>, "walhol" <hollerwal (AT) aol (DOT) de>
wrote:

There is no function. You need to add a new field to your database.

MyCreationDate Date field Auto-enter option Creation Date

This will store the date when the record is created.

You will not be able to backdate existing records.

Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)