108 reputation
18
bio website yola.com
location Illinois
age
visits member for 2 years, 5 months
seen Aug 18 at 21:33

Front-end developer working at Yola.


Sep
24
awarded  Autobiographer
Jul
28
awarded  Notable Question
Sep
23
awarded  Popular Question
Jan
5
awarded  Student
Oct
8
awarded  Tumbleweed
Oct
2
revised REST service $filter Date column
Added a section describing why I chose my own solution.
Oct
2
awarded  Scholar
Oct
2
accepted REST service $filter Date column
Oct
2
comment REST service $filter Date column
I updated the post to show that I actually am using the ISO format. I like a library called Moment.js for dates. I tried using the SP date field as you describe, but it had all kinds of problems with inconsistencies in time zones. I guess what bugs me most about using the built-in Date format is that you receive the date in one format, and the queries use a different format. This is silly and error-prone. I'm going to stick with using my own date fields and Moment.js, which has no problems parsing it and formatting using the ISO standard on both sides.
Oct
2
revised REST service $filter Date column
edited body
Oct
1
asked REST services - Flag to force PUT and POST to return the record instead of nothing?
Oct
1
comment REST service $filter Date column
Hmm. Although I agree that you've boiled the syntax down to something that's a bit more manageable, it still seems strange to have to convert back and forth from dates to strings to dates. Since the data has to cross the http wire as a string, and I can't manipulate it server side, why wouldn't I just use a column that's a more friendly string format? If I just need to be able to compare these dates via really simple queries, why should I keep converting them back and forth? What does it buy me? Thanks for your answer! I'm curious to explore this idea a bit more...
Sep
28
comment REST service $filter Date column
Thanks for your answer, and this would probably work, but I basically gave up on using SharePoints ugly date fields for anything when I figured out that I can treat them as strings, as indicated in my answer.
Sep
28
answered REST service $filter Date column
Sep
27
asked REST service $filter Date column
Aug
14
comment Accessing list data from another site collection or web application using REST services?
Whoops! Thanks @Abe Miessler.
Aug
14
revised Accessing list data from another site collection or web application using REST services?
added 117 characters in body
Aug
14
answered Accessing list data from another site collection or web application using REST services?
Aug
13
awarded  Excavator
Aug
13
awarded  Editor