If we remember our SharePoint Power Tip on calculated fields, then we'd know we can use Excel formulas to make this work the way we want. In my case, I was trying to display the age of a ticket in days, on it's InfoPath customized form. Sounds easy enough right?
NOW() - Created
That should do it, right?
Unfortunately, that displayed a value with fractions. Not quite what we want. OK, so let's just round the thing then, and while we're at it, round it to 0 decimals thus:
ROUND(NOW() - Created, 0)
Alas, that did not do it either. Hopping into Excel, I used text formatting to achieve the goal. The final calculation was:
=TEXT(ROUND(NOW() - Created, 0), "0")
Happy coding.
C
The SharePoint Knowledge Collection of Cornelius J. van Dyk, an 9 x SharePoint MVP
Subscribe to:
Post Comments (Atom)
SharePoint Remote Event Receivers are DEAD!!!
Well, the time has finally come. It was evident when Microsoft started pushing everyone to WebHooks, but this FAQ and related announcement...
-
Ever wondered what the new SharePoint Online URLs are all about? Take for example https://cjvandyk.sharepoint.us/:x:/r/sites/Site1... What ...
-
Every so often, you run across the need to redirect a page somewhere else, like after a server migration when DNS isn’t used. By simply addi...
-
When using NuGet, we can easily run into assembly reference issues. A notorious error message is: CS0012: The type ‘System.Object’ is def...
No comments:
Post a Comment
Comments are moderated only for the purpose of keeping pesky spammers at bay.