zenmom Posted July 15, 2007 Share Posted July 15, 2007 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! Link to comment Share on other sites More sharing options...
comment Posted July 15, 2007 Share Posted July 15, 2007 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 ). Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6123 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now