This is the script step I have.

Set Field[GetAsText(Get(CurrentDate)) & " " & Bailbond::Initials]

I want to add a timestamp to it, on the end, but I can't figure out how to do it. Would someone help please.

Thanks

Mitzi

Hi Mitzi,

Set Field [ [color:blue]Get ( CurrentDate ) & " " & BailBond::Initials & [color:red]" " & Get ( CurrentTime ) ]

Portion in blue is all that is added in the calc box. Set calculation result to text.

Oooops - I'm a bit tired. You might want a space between the initials and timestamp (see red above).

LaRetta :wink2:

Edited November 11, 200619 yr by Guest
Added red to calc - geez.

Thanks so much. I'll give it a try.

Mitzi

Ok. I've got that working. Now I have another question.

I want to make it where a timestamp is placed on a layout when a new record is started. I want the original time the record was started to be permanently displayed on the layout. I am trying to keep workers from shuffling their work off to later shifts and this will allow me to make sure they are performing their own work.

Thanks

Mitzi

Hi there

Create a field 'time in' remembering to set it's type to 'time' (bottom r/h/c)

Select the field from the list in define database and click on the 'options' in the bottom r/h/c.

Select the auto enter tab and click the creation box and select 'time'

This field will then always contain the time of the creation of the record.

Display this field wherever you feel it necessary but do not forget to set it's behaviour so that it cannot be entered in browse mode just to save any confusion.

Remember also that you can format the way that the time is displayed by selecting the field in layout mode and using the 'format' pull down menu where you will find time as one of the options

HTH

Phil

thank you, this is just what i needed...I appreciate all of the help here