September 2, 200916 yr Hi all. I am think I am close but I am stuck. I have spent 2 hours trying to figure this out and I am at my breaking point. I have text field with a timestamp in it. I want to do date math between that field and the current date. My result is a huge number though. Any help would be appreciated as always.I have attached 2 photos one of the script and one the debugger watching the values. Excuse all the work fields just trying to debug it.
September 2, 200916 yr I have text field with a timestamp in it. That's not a good starting point. If it's a timestamp, you should use a field of type Timestamp to store it. Assuming you want the difference in days between the timestamp and the current date, you can then try: Get ( CurrentDate ) - GetAsDate ( YourTimestamp )
Create an account or sign in to comment