New answers tagged

0

You can use momentjs to do the conversions to the local time. http://momentjs.com/timezone/docs/#/using-timezones/ This is an example from the documentation: var m = moment.tz("2013-11-18 11:55", "America/Toronto"); You'll need to look through the documentation to find out how best to meet your needs.


0

This is entirely possible to do with Client Side Rendering. One way to do it would be to add a column to the list called "Days Overdue", and then use a list view override for that field to do the calculations and display your red text message. However, then you have added a column to your list that you are not actually using to store any data. As it turns ...


0

How to do it with a Calculated Column: http://viewmaster365.com/#/How SO answers you should have found: How to use Today and Me in Calculated column Can anyone color code a column with an if statement? With CSR (+ iCSR.js library from iCSR.GitHub.io Changing A Lists row color based on a number Conditional Formatting Based on Number Range


0

I don't have the exact code but you can achieve using JSLink functionality by adding script in List view and do the calculations. You need to refer this post for doing it : JSLink reference


0

Date fields are never truly empty, so the option doesn't exist. An "empty" date field is actually set to 1/1/0001. So for your specific project, forget the whole "storing the string values of the dates" thing, that won't work. Instead, set up the workflow to perform the action if both Date fields are greater than 1/1/0001.


0

Syntax and a working solution Works in SP 2013. Geq><FieldRef Name="EventDate"/><Value Type="DateTime"><Today OffsetDays="-30"/></Value></


0

Do you know that this feature can be achieved using the multiple line of text field and enable 'Append Text to Existing Text' (Just make sure versioning is turned on) as the screen shot here shows: once you do that you can keep track of all the comments with time stamp like that: you can use that in your infoPath and you don't need to do any coding :)


0

It seems that the problem was the formatting of string value as a valid SharePoint datetime. wjervis's comment is right; I have to adapt my source code for get the selected date "hour and minutes" in my form and using the toISOString method. So, if I need datetime with the ISO 8601 format; I use the following code: // This is the date that I select in my ...


0

Learn to use Calculated Columns http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List Weeknumber is a beast, see the example in the WeekDay Function Month is =MONTH( [YourDate] )


3

This works for me: =[Today]+14 And this is end result:


2

You would want to use [Today]+14 for this.


0

Yes, DateOnly="true" throw error. So, you can replace value by script like this: wrap the field <span class="myDate"> <SharePointWebControls:FieldValue runat="server" FieldName="Created" id="CreatedOn"/> </span> set value by js : if($('.myDate').text() != ""){ var date = $('.myDate').text().split(' ')[0].split('/') ...


0

I tried to get your point and also searched on the web for the same. Please go through this thread Column calculated value to get the current date time? and let me know if it help you. Thanks


0

What you want to do can easily be done by using retention (Library/list settings>information management> enable retention). Please note that in SP2013 retention only works with 2010 workflows. You want to add a retention stage that starts after date field created +7 days with the action set to run your workflow. The result is that after 7 days your ...


0

It is not the datediff that is causing the problem. That function does return 0 when you have the same date with different times. I am not familiar with the formula that you used but I noticed that it is adding 1 day to the datediff result. Tested the formula without the +1 and it looks OK. Give it a try (replace the column names before, and I had to ...



Top 50 recent answers are included