Hot answers tagged

7

The problem is that you are using the method getDay(). That method will give you the day of the week in this case 3. You should be using the method getDate(). var dt = new Date(dtTest.getFullYear(), dtTest.getMonth(), dtTest.getDate()); -Hope it helps.


4

Yes it's normal, You should be aware of the [Today] and [ME] can't be used in the Calculated Field, Please check all details and alternative solution at How to use Today and Me in Calculated column Meanwhile, In your view, you can use filter directly to filter the files modified within the last 7 days as


3

You need an IF statement outside of the ISBLANK IF(ISBLANK([Closed Date]),"no date available", yourlongTEXTformattinghere)


3

http://viewmaster365.com/365coach/#/Calculated_Column_Functions_List The WORKDAY function does not exist in SharePoint the WEEKDAY( date , [format] ) function returns the daynumber, where sunday=1 with the default non-specified format WEEKDAY daystoadd sunday : 1 3 monday : 2 3 tuesday : 3 3 wednesday 4 5 thursday: 5 ...


3

In views, the [Today] column will work as a filter. In your view you would have a compound filter: Report Complete is equal to and leave the field blank. And Site Complete is greater than or equal to [Today]-30 This is looking for blank report complete fields with the additional filter that the site complete is more than 30 days ago. Is that what you ...


3

You have to go the other way around, Not convert your date to Text but convert the text you use to compare to a Date. That will also make it safe to use in any language provided your field IS a Date field IF( [GE Internal Report Receipt] = DATE( 1900 , 1 , 1 ) ,"Complete" ,TEXT([GE Internal Report Receipt],"dd/MM/yyyy") ) Note that ...


3

When you set the field type, did you format that date block as the appropriate setting?


3

Use ISBLANK(Created) to check whether the item is new one. One thread for your reference Validation formula on new items only Update: Try below formula which I tested. =IF(Created=Modified,[Load Date and Time]>=TODAY(),TRUE)


3

This formula for Followup column should solve your problem: =IF(WEEKDAY(Datum,2) < 4,DATE(YEAR(Datum),MONTH(Datum),DAY(Datum) + 2), IF(WEEKDAY(Datum,2) < 7,DATE(YEAR(Datum),MONTH(Datum),DAY(Datum) + 4), (DATE(YEAR(Datum),MONTH(Datum),DAY(Datum) + 3)))) Just replace the "Datum" in my formula with the name of your Date column.


3

Good day! Here is a source for some syntax around calculated columns! Source: https://support.office.com/en-us/article/examples-of-common-formulas-in-sharepoint-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3 For your problem, you want to add 6 months contract expiry date. Here is the formula: =DATE(YEAR([ContactExpiry Date]),MONTH([ContactExpiry Date])+6,...


3

It's a normal behavior, The calculated column formula is only calculated/updated in the following cases: Add New Item. Update Existing item. Update the calculated column itself in the List Setting! Check also, The Supported and Unsupported Columns In SharePoint Calculated fields


2

You might try logging the output of Current Item:EndTime to the workflow history list. It may be that the comparison still holds true that Current Item:Endtime > Today and so the loop is continuing. You could wait and see if the task gets assigned once that comparison is false and you break out of the loop. Another option would be to set a boolean ...


2

You can write a piece of JavaScript code in the page by placing the content editor web part or script editor web part. Or you can include the script in your web part only if it is JS based. Below is the REST query which may help you to fetch the last modification date-time of the list. _spPageContextInfo.webAbsoluteUrl + '/_api/web/lists/getbytitle("...


2

there are two possibilities for actual date/time. add a calculated column with =DAY(NOW()) or =TEXT(YEAR(NOW());"####") or find expression what suit your self and make it hidden for users in content type. in workflow set wf variable type date to current date (by clicking on ellipsis) Set Variable: Date to Today


2

If you're looking to show your list item twice, once for each date range (like planning phase, execution phase), then Calendar Overlays may be your quickest answer. Here's an older MS page for adding an exchange calendar. They share some of the same steps, but here's some quick steps for adding the SharePoint Calendar. Create 2 Calendar Views on your list,...


2

Try this below PowerShell it will run for SharePoint 2013: Add-PSSnapin Microsoft.sharepoint.powershell -ErrorAction SilentlyContinue $Webapp = "http://sp2013vm:5555/" $site = Get-SPSite -webapplication $Webapp -Limit All $site | Get-SpWeb -Limit All | Format-Table -Property LastItemModifiedDate,URL -AutoSize | Out-string -width 3000 > "C:\...


2

So, it ended up being a very simple solution to this. The date I was using to update the items was a string, and I needed to convert it to a date object. There didn't need to be any changes made to the validation formula or date formatting aside from converting "MM/dd/yyy" by using this ($newItemDate was the original date string): $newItemDate = [datetime]...


2

You can get the date format from regional settings: var ctx = new SP.ClientContext(siteUrl); var web = ctx.get_web(); ctx.load(web); var regionalSettings = web.get_regionalSettings(); ctx.load(regionalSettings); ctx.executeQueryAsync( function(sender,args) { console.log(regionalSettings.get_dateFormat()); console.log(...


2

You're fighting the limitations of views not having grouping capability and calculated fields not allowing [today] to work. We do this a lot - we have an item with up to 10 different due dates (an item is something that goes through a process with 10 sequential steps). What we finally did was to create a wiki page and added the list multiple times per ...


2

You could try this instead, to calculate accidents I need to use a reporting year which runs from 01/11/2017 - 31/10/2018. Happily, we both have the same reporting year/financial year. We need to create some calculated fields and some 'single line of text' fields. YEAR To split off the year data, create a 'single line of text' field with the formula ...


1

I think I got it. I should have been using this: =AND(Day>TODAY()-14,Day<TODAY()+1,Day>datevalue("6/21/2017"),Day<datevalue("8/26/2017"))


1

As @Monica said, calculated columns update only when they are created or modified. You'll get static values, if the columns are not edited. But what you are looking for is DATEDIF method of calculated columns. The syntax will be: =DATEDIF([date1], [date2], "D") I'll suggest you to use Timer Job/workflow depending upon you environment.


1

For calculate formula, calculation happens when you edit the item. That means if you edit the item today, current month will be taken as "June" and formula will show appropriate result. But even if you navigate to the view after 30 days, it will still show result based on "June" and not current month. This is because calculated column updates the result on ...


1

You do not need a library in order to display it like that. var dateString = "2017-5-24 00:00:00"; var date = new Date(dateString); date.toLocaleDateString("en-US", { year: 'numeric', month: 'long', day: 'numeric' }); // May 24, 2017 For further options you may also take a look at this post about date formatting.


1

Try below code: String.format("{0:MMM} {0:dd} {0:yyyy}",new Date(ows_Date)); In the new Date()function, pass the column name of the date field Excellent reference - Changing date format using javascript Update - you need to write a custom function as below: var monthNames = ["January", "February", "March", "April", "May", "June", "July", "August", "...


1

This is what you are looking for: =TEXT([Start Date],"mmmm")


1

Good, you found the issue with the internal name yourself, that is always the best way to make learning stick. Some tips avoid creating new List Fields with that "easy" SharePoint UI, that's how you get those stupid weird internal names. Instead create new Fields in the List settings, where you specify the Internal name first (without spaces!), then rename ...


1

Try to create a custom item style that will show the Title and date as the following Steps: via SharePoint Designer > Open your Root site. Go to all files > Style library > XSL Style Sheets > ItemStyle.xml Create a copy from ItemStyle.xml to allow rollback then > Edit it as advanced mode. Add new style with name TitleDate as the following <xsl:...


1

More than likely the two objects you are comparing in the IF statement are not equal because one is a date the other is text. Try this: IF(TEXT([GE Internal Report Receipt], "dd/mm/yyyy")="1/1/1900","Complete",TEXT([GE Internal Report Receipt],"dd/MM/yyyy")) That should make the date object into text so the comparison is apples to apples.


1

Okay i fixed it, It was because i was adding the date filter web parts to the library itself, and i was supposed to create a page for it and add my web-parts in there.


Only top voted, non community-wiki answers of a minimum length are eligible