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 ...
-
When using NuGet, we can easily run into assembly reference issues. A notorious error message is: CS0012: The type ‘System.Object’ is def...
-
Have you ever started creating a list view in SharePoint and because you're experimenting, you chose to make it a "Private" vi...
No comments:
Post a Comment
Comments are moderated only for the purpose of keeping pesky spammers at bay.