Timestamp question

[zenmom]

Okay, next question: Is it possible to use the value in a timestamp field to derive a date or time value for another field? I.e., timestamp field value is "2/15/06 3:15pm", calculated fields might be Date2 with value "2/15/06" and TimeMed "3:15pm".

I did look in online Help, but didn't see anything along those lines. Any suggestions appreciated!

[comment]

You could make both calculation fields simply equal the timestamp field - setting the type of result to Date or Time is enough to extract the relevant portion.

If you need to convert explicitly (for example to use the result in further calculations), use GetAsDate ( timestamp ) and GetAsTime ( timestamp ).