DateDiff("w", [Created On], [Updated On] )
It seems to work for me today, not without other frustrations. Unsure if it was the Data Type or Display format, but it was happening on both 12.1.05 and 12.1.08.
- Not sure when "now" is, should be system time, and my system time is correct. If i compare "now" to a ticket that was created today, i get 736,668 days. That’s over 2018 years, so "Now" is before Jan 1st, 0001AD?
- Can't seem to add the 736668 days during the DateDiff Formula, doesn't do that math, just adds the characters:
I ended up getting what I needed, and then added "yes/no" IF columns so I could create crosstabs for Tickets created within 7 days, and tickets updated within 7 days:
Its seems "Now" is a static date. Footprints is telling me that "Now" and "Yesterday" after different by 736698 days. "Now" and tickets made today are 736699 days apart.
Giving up doing this via FP/SA.