Query format for date argument

Home › 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.