Separate the date & time from Current Host Timestamp?

August 23, 200619 yr

What's the best way to separate the date and time from the server's time stamp?

I'd like to upgrade an employee timeclock by using the network clock instead of each seat.

Thanks in advance,

Stephen Ray

August 23, 200619 yr

If I understand correctly, a calculation with:

Get ( CurrentHostTimeStamp )

... and format the calculation as DATE.

Do the same for time.

August 23, 200619 yr

Author

The present solution uses separate date and time fields. I would like to separate the host timestamp which combine date and time.

If separated, it would be easier to update a number of scripts and calcs.

TIA,

Stephen Ray

August 23, 200619 yr

So you want to take the HostTimeStamp and just produce a date from it?

August 23, 200619 yr

Author

Yes, the date as a separate field and also the time as a separate field.

August 23, 200619 yr

Then try my suggestion? It can be a calculation or even used within a Set Field [ ] script-step or used via Replace Field Contents. It can even be formatted like any other date field (via field-level format, ie, right-click field and view date formats. :wink2:

If you take a timestamp field and (within a calculation), specify it as DATE - or even set a date field with the calc, the result will only be the date portion of the timestamp. Cool, huh? I adore timestamps.