Query format for date argument

› Forums › vLooup for SharePoint › Query format for date argument

Viewing 1 reply thread
  • Author
    Posts
    • June 23, 2016 at 14:42 #12094
      Chris Diltz
      Participant

      I can’t seem to figure out the correct argument for a date formula. I want to return list records where a date column equals Today-1 (yesterday). Any know how to do this?

    • June 29, 2016 at 05:46 #12155
      Alexander Bautz
      Keymaster

      Try it like this:

      <Where>
<Eq>
<FieldRef Name='YourColumnName'/>
<Value type="DateTime"><Today OffsetDays="-1"/></Value>
</Eq>
</Where>

      Alexander

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.