Inserting Date & Time

[Totes]

Hi,

I have a button on my layout which will insert the date and time, however it all comes in as one long line...

6/22/20071:04:51 PM

Is there a way to add a space between the date and time?

Thanks,

James

[LaRetta]

Hi James,

Set the date and time?

Sure, set the field with Get ( CurrentTimeStamp) and it'll have a space. What are you currently using? If you are manually combining a date and time field, insert the space yourself as:

theDate & " " & theTime

UPDATE: And if your field (being set) *is* a timestamp field, it'll be much more useful in the future.

LaRetta

Edited June 22, 2007 by Guest
Added update

[Totes]

Laretta,

I have created a script and currently use the two canned scirpts:

Insert Current Date

Insert Current Time

and I have selected the "Go To target Field"

I have attached the script to my button, and as I stated it does the job, but it places it all in one line.

So, do I understand that I should not use the canned script?

Never Mind the question above...I followed your directions and it worked like a charm!!

Thanks for your time.

James

Edited June 22, 2007 by Guest

[AudioFreak]

Ah just use Set Field. In your script just make it

Set Field[Your Table::Your Field ; Get( CurrentTimeStamp)

Another way is like Laretta was suggesting and it would look like.

Set Field[Your Table::Your Field ; Get ( CurrentDate )&" " & Get ( CurrentTime )

Both will produce the same thing.

Michael

[Totes]

I cant read your postings for laughing at that darn cat with the headphones!!!!!

J