Separate the date & time from Current Host Timestamp?

[Stephen Ray]

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

[LaRetta]

If I understand correctly, a calculation with:

Get ( CurrentHostTimeStamp )

... and format the calculation as DATE.

Do the same for time.

[Stephen Ray]

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

[LaRetta]

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

[Stephen Ray]

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

[LaRetta]

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.

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.