New answers tagged date-time
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 ...
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.
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
Try this =IF(TEXT([Date & Time],"dddd")="Monday",TRUE,IF(TEXT([Date & Time],"dddd")="Friday",TRUE,TEXT([Date & Time],"dddd")="Thursday"))
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 ; ...
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