July 12, 200421 yr 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.
July 12, 200421 yr Author Duh! I forgot to divvy the timestamp into the individual "words"...so it does behave as a text field after all. Thanks!
July 12, 200421 yr 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.
Create an account or sign in to comment