New answers tagged date-time
Figured it out without any custom code! I just added this to the function: substring-before(field1, "T") This extracted all the text before the "T"!
If the date you are trying to format is part of a string value with other than just a date, you cannot change it. I.e. if you're @Description field contains a string like "This is my string with a date 06/11/2016 that I want changed to Sunday, November 2016" then you cannot change the date format. The example you mention that you've copied, that just ...
Constellation Solutions has a low-cost employee anniversary and birthday solution that can be added to an on-prem or Office 365 instance of SharePoint. It uses the User Profile service to pull the current employees. You can find out more information at Employee Birthdays and Anniversaries in SharePoint
Someone suggested the MomentJS library, which is great for doing Date calculations and transformations. But 2015/10/20 PM 06:09 is an invalid Date notation so MomemtJS won't make it valid either. I would suggest to find the cause why your environment is outputting this invalid notation and fix it at the source. In the mean time you can change the string ...
You should change your String date format I have tried with 2015/10/20 06:09 PM var t = new Date("2015/10/20 06:09 PM"); t = t.toISOString() alert(t);
Using below code you can get ISO format of SharePoint created field value string objTime=SPUtility.CreateISO8601DateTimeFromSystemDateTime(Convert.ToDateTime("2015/10/20 PM 06:09")); Output: 2015-10-20T18:09:00Z
Here is a modified calculation that I have used before and believe it will benefit you as well. =DATEDIF([Start Date],[End Date]-(MOD([Start Date],1)>MOD([End Date],1)),"d")&" days, "&TEXT(MOD([End Date]-[Start Date],1),"hh "" hrs, "" mm "" mins""") For example: If a user enters 8/1/2016 8:00 AM as start date and 8/10/2016 12:30 PM as end date, ...
Top 50 recent answers are included