Query Parse.com Date Column

Question

I have a class called Events which contains a column called EventDate of type Date. In my query what format does the date need to be in to query successfully? The query succeeds, but always shows me 0 events. I have one event in my class which should match the criteria that has an EventDate value of Feb 14, 2014, 03:48. Below is a snippet of my code:

ParseQuery<ParseObject> query = ParseQuery.getQuery("Events");
query.whereGreaterThanOrEqualTo("EventDate", new Calendar.getInstance().getTime());
query.findInBackground(new FindCallback<ParseObject>() {

        @Override
        public void done(List<ParseObject> events, ParseException e) {
            if (e == null) {
                Log.d("Events", "Total Events:  " + events.size());
            } else {
                Log.d("Events", "Error:  " + e.getMessage());
            }

        }
    });

Date should be correct. Does your query work if you comment out the "whereGreaterThanOrEqualTo"-statement? — Marius Waldal
– Marius Waldal, Commented Feb 13, 2014 at 9:00

Brian Anderson · Accepted Answer · 2014-02-13 13:36:37Z

1

I figured out the issue. I was not aware that the date/time stored in my Parse class was stored in GMT time. When I convert the current local time to GMT time and send that I am able to get my query results.

answered Feb 13, 2014 at 13:36

Brian Anderson

2372 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rajendra Khabiya Over a year ago

Can you please your sample code here, It will help other.. Thanks!

Collectives™ on Stack Overflow

Query Parse.com Date Column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related