What does "dateTime" mean?

Options
Rachel Bender
Rachel Bender ✭
Ancient Membership Facilitator 1
in API
I'm trying to query the ContactPayment entity by Date. I see that the data type is "dateTime". However, there are many interpretations of dateTime - can someone tell me the right dateTime format? I have tried ISO 8601 and RFC 2822. Thanks

Comments

  • Rachel Bender
    Rachel Bender ✭
    Ancient Membership Facilitator 1
    Rachel Bender:
    I'm trying to query the ContactPayment entity by Date. I see that the data type is "dateTime". However, there are many interpretations of dateTime - can someone tell me the right dateTime format? I have tried ISO 8601 and RFC 2822. Thanks
    I believe I figured this out, see my request below. I'm not getting any errors, but this is taking about a minute to return, and I'm only querying a range of 4 days! Can someone look into this? Please let me know if you need any further info to troubleshoot this. 4F000asdfaf69BSELECT * FROM ContactPayment where Date >=06-19-2013 and Date <=06-23-20131001
  • Rachel Bender
    Rachel Bender ✭
    Ancient Membership Facilitator 1
    Rachel Bender:
    I believe I figured this out, see my request below. I'm not getting any errors, but this is taking about a minute to return, and I'm only querying a range of 4 days! Can someone look into this? Please let me know if you need any further info to troubleshoot this. 4F000asdfaf69BSELECT * FROM ContactPayment where Date >=06-19-2013 and Date <=06-23-20131001
    Second attempt at pasting xml .. OK, xml is not working, here's my query text: SELECT * FROM Event where CreateDate >=06-09-2014 and CreateDate <=06-09-2014

Categories