chemparrot Posted July 12, 2004 Posted July 12, 2004 I have a timestamp field that auto-enters when I create a new record. I want to pull the date portion of the timestamp using a calculation, but it seems that timestamps don't evaluate as text, so GetAsDate doesn't work, and I don't see any function that would do this specifically. Anyone know how to get the date from a timestamp? I guess I could always change the field from a timestamp to auto-entering the current date, but really, there should be a way to do this.
Lee Smith Posted July 12, 2004 Posted July 12, 2004 Why not just have your date field use the option of Creation Date?
chemparrot Posted July 12, 2004 Author Posted July 12, 2004 Duh! I forgot to divvy the timestamp into the individual "words"...so it does behave as a text field after all. Thanks!
MoonShadow Posted July 12, 2004 Posted July 12, 2004 Lee asked ...Why not just have your date field use the option of Creation Date The idea of the new timestamp is to combine the fields so one doesn't have to create two separate fields (creation date and creation time). It's a nifty feature.
Recommended Posts
This topic is 7508 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