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@aol.de> wrote in message 
news:dnbjkr$qc2$1@news.mch.sbs.de...
> 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
>
> 

Yes I know Get (creationDate), but I use the German Version. Hole(??????)
Walter
"Bill Marriott" <wjm@wjm.org> wrote in message
news:dnbm4q$sej$1@domitilla.aioe.org...
> 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@aol.de> wrote in message
> news:dnbjkr$qc2$1@news.mch.sbs.de...
> > 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
> >
> >
>
>

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@aol.de> wrote in message 
news:dnbpbu$k1t$1@news.mch.sbs.de...
> Yes I know Get (creationDate), but I use the German Version. Hole(??????)
> Walter
> "Bill Marriott" <wjm@wjm.org> wrote in message
> news:dnbm4q$sej$1@domitilla.aioe.org...
>> 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@aol.de> wrote in message
>> news:dnbjkr$qc2$1@news.mch.sbs.de...
>> > 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
>> >
>> >
>>
>>
>
> 

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

> Yes I know Get (creationDate), but I use the German Version. Hole(??????)
> Walter

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)