Query on date

Forums vLooup for SharePoint Query on date

This topic contains 2 replies, has 2 voices, and was last updated by  chgrnet 2 months, 3 weeks ago.

  • Author
    Posts
  • #21259

    chgrnet
    Participant

    I am using vLookup plugin backend v2.2.121 with IE 11 on a SP 2010 site.

    Can you query a vLookup on a date? If you can, what date format would be used to select a specific date in the past? The last time my child list went over 5,000 items it caused all my vLookups to the list to break and I am hoping this indexed date column will allow me to keep this from happening.

    If you have any other suggestions to keep vLookup working on a child list that goes over 5,000 items, please let me know.

  • #21287

    Alexander Bautz
    Keymaster

    Hi,
    The CAML query format for a date value is ISO8601 like this:

    2018-06-28 17:09:17

    You might have to specify it like this:

    2018-06-28T17:09:17Z

    but this depends on the version of SP you are running.

    In general, indexing the fields you use in the query should make the vLookup work past 5000 items – how is your CAML query configured?

    Alexander

    • #21294

      chgrnet
      Participant

      Yes, I did make sure the columns I am using are indexed. In the past when the child lists when over 5,000 all the vLookups failed and they did not appear to be caring about the indexed fields. This was a later version, so hopefully with the version I am using now (June 20118) it will work. I wanted to use a date in case what I had did not work.

You must be logged in to reply to this topic.