Hi all,
I was working on some SharePoint K2 integration tasks when I realized that SharePoint (2010) returns some 'overhead' data when I connect to calculated or lookup fields I occacionally use in lists and libraries. In particular we had a calculated datetime column that added 25 days to another column of the same list. In my process I have to compare the actual date (today) with this column which wasn't so easy because of the leading ID#; information of that column. What is the best practice to get rid of the leading characters? Just using inline functions? I am a bit dissapointed because K2 could have provided a function for this because I assume everybody has issues with it.
Many thanks!
Joachim