Using Today() in a script calculation in the data model that counts the # days from today to when a past start date for a help desk ticket. The Data Model is consistently returning the correct # days, but the Application (we build data model then binary load that model for the application) is not.
We run this on a server, and the Application is refreshing every morning, so while I recognize that today(), today(0), today(1), and today(2) all mean something different...in this case shouldn't they all return the same "date" from which to start the calculation?
0 Date at script run
1 Date at function call
2 Date when the document was opened
These all seem relative to the system clock...is there not (like Excel) a version that declares "Here is Today's Date?"