Date math

[jeffw]

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.

[comment]

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 )