How to add a dynamic date filter in FSM report?

I just started playing around with creating report from a list view in FSM and adding report filters to help me run transactions query faster. But so far I cannot figure out a way to put a dynamic date filter (ex: Today date), or filter that "Starts with" or "Contains" a certain account number. Does anyone know where would be a good resource for me to find out how to build these filter?

Find more posts tagged with

Accepted answers

All comments

rkhickam

I have a report that captures PO's for a specific requesting location, within the filter - we use following filter and the report is scheduled to run 7 days a week

(RequestingLocation = "MAIN LAB 10") and (PurchaseOrder.PurchaseOrderDate >= (current date - 1))

vy-vo

You're a lifesaver Bob!!! This works perfectly for my report.

Dr. Awesome

Vy - could you not find where to add a Filter or did you find where to add a Filter fine but once you got there it wasn't clear what to do or how?

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help

Copyright © 2025 Infor. All rights reserved.