July 15, 200718 yr 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!
July 15, 200718 yr 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 ).
Create an account or sign in to comment