This script is working every now and then but not every time. It's pasting the date & initials but leaving off the time. It's strange because every now and again it will paste the time too, but mostly leaving off the time. I need it to paste all 3 each time.

GetAsText(Get ( CurrentDate ))& " " & Bailbond::Initials & " " & GetAsText(Get ( CurrentTime ))

Thanks in advance for any help.

Are you sure your field isn't just to small to accommodate the time value -- i.e. have you tried clicking into the field to see it's entire contents?

Probably not the issue, but its worth a try.

Also, why are you using get as text? If you want to format the values in a particular way, you can use the Hour, Minute, Day, Month, and Year functions on the Get(CurrentTime) and Get(CurrentDate) functions respectively.

No the field is plenty long. Why "getastext"? I have no idea. I don't know what I'm doing and just guessing as I go. Could you re-write the script for me and post it here? Any help is appreciated as I do not know what I am doing.

.. GetAsText isn't an issue, it's just un-necessary.

I'm not sure this will help but try...

Get(CurrentDate) & " " & Bailbond::Initials & " " & Get(CurrentTime)

Otherwise (not that i think it will make a difference... ) try

Let( TS = Get(CurrentTimeStamp) ;

Date( Month(TS) ; Day(TS) ; Year(TS)) & " " & Bailbond::Initials & " " & Time( Hour(TS) ; Minute(TS) ; Seconds(TS) )

)

Finally, you shouldn't be "pasting" the value, you should be using Set Field... which i'm assuming you are doing.

Edited November 17, 200619 yr by Guest

ok, none of these are working. The field has plenty of room in it. There must be something else I am doing wrong.

p.s. I am using set field

Can you attach the file? You can delete all unecessary layouts/ relationships / data first.

schwooom! I have no idea what you're talking about. What do you mean attach a file? Delete stuff? Sorry, but you're going to have to be more explicit with me as I am a severe novice.

Hi Mitzi

Try this

Setfield(Yourfield;Get( CurrentDate )& " " & Bailbond::Initials & " " & Get(CurrentTime ))

Let me know how that goes

Phil

.. I am assuming thats what they have been doing.

Anyway, what i was saying was attach the filemaker file so we can try and work out what the problem is -- it's hard to just go on what you're telling us here because it sounds unusual

Hi Genx

I just stripped out the get as text elements (just in case) and I was just keeping it simple, hence no explanation.

It works in a script on my machine anyway although I didn't try putting the get as text bits back in to see if it failed.

Phil

I'd quote myself, but i'm too lazy -- read my second post -- i did test the GetAsText() ..

This is just a general note, it really has no effect though it is a bit redundant.