Tag Info

New answers tagged

0

I was able to get the filtering working by using datetime prefix in SharePoint Online (Office 365). Here is an example of a REST query that pulls the dates back in a range. _api/web/lists/getbytitle('Expenses')/Items?$filter=Expense_x0020_Date ge datetime'2015-04-06T00:00:00Z' and Expense_x0020_Date le datetime'2015-04-07T00:00:00Z' Here are the ...


0

Are you using the Content Organizer as is or have you created a custom workflow that moves the documents? I have a client that was having the same symptoms. We didn't find the root cause but when we stopped using the custom workflow he had built the problem went away.


0

Why, why all those nested IFs?? The WEEKDAY function returns a number 1-7 for weekdays, starting at 1=Sunday So to validate Monday, Thursday and Friday use: CHOOSE( WEEKDAY([Start Date]) ,false ,true ,false ,false ,true ,true ,false ) An optional second parameter makes the WEEKDAY function start at other days of the week


1

Try this =IF(TEXT([Date & Time],"dddd")="Monday",TRUE,IF(TEXT([Date & Time],"dddd")="Friday",TRUE,TEXT([Date & Time],"dddd")="Thursday"))


2

According to the protocol specification document Edm.DateTime (VJsonDateTime) has the following JSON format: VJsonDateTime= quotation-mark "\/Date(" ticks [("+" / "-") offset] ")\/" quotation-mark ticks = *DIGIT ; ticks is the number of milliseconds since midnight ; ...


1

I believe the problem is that you can't have : in your url path. However, you can have it in a querystring (not path). So try this: /_api/web/RegionalSettings/TimeZone/utcToLocalTime(@date)?@date='2015-03-25T13:20:00'



Top 50 recent answers are included