[Wactclc-alma] Process type date filtering

[Guidry, Wade]

I'll put in this in the meeting notes as well, but for those of you who were on the call today, here is the correct syntax for filtering on process type date in the Physical Items subject area, when you want to filter relative to current date:

      "Physical Item Details"."Process Type Date" > (TIMESTAMPADD(SQL_TSI_DAY, -3, CURRENT_DATE))


In this example, the formula will select all process type dates greater than 3 days in the past (current date minus 3 days)

Kudos to Dan, as he was the one who mentioned misplaced or missing parentheses, and that's exactly what I was missing this morning, those outer parens that are underlined above.



Wade Guidry
Library Consortium Services Manager, WACTCLC
wadeg at bigbend.edu<mailto:wadeg at bigbend.edu>
(509) 760-4474
http://www.wactclc.org<http://www.wactclc.org/>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ctc.edu/pipermail/wactclc-alma_lists.ctc.edu/attachments/20220426/53d27d71/attachment.html>