x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 3 replies
  • Subscribers 105 subscribers
  • Views 208 views
  • Users 0 members are here
Browse Forums
Announcements
311
topics
370
replies
Business Object Interface
1k
topics
7k
replies
Core Financial Modules
2k
topics
8k
replies
Customization and Productivity
3k
topics
12k
replies
Distribution, Manufacturing, and Applications
2k
topics
7k
replies
General Discussion
1k
topics
4k
replies
Partner Cloud
57
topics
117
replies
Payroll, Time Tracking, and Job Cost
794
topics
1k
replies
Reporting and Analytics
984
topics
3k
replies
Sage CRM for Sage 100
166
topics
361
replies
Technical and Installation
2k
topics
10k
replies
Year-end Forum
90
topics
237
replies
Michael Kaney

Business Insights Explorer "Filter Builder" Dynamic date

Posted By

Hi all

I searched but did not seem to find an answer to this specific question.

In Business Insights Explorer, I want to use the filter to show only sales orders with ship dates before today. There are a few options for "7 days or older, 30, 60, etc." but no 1 day. is there a keyword/variable I can type in that will always be the current date? Using less than and typing today just populates todays date. Maybe there is some other logic I could use that I am not thinking of?

Thanks in advance!

  • 0

    On Sage 100 ERP 2024 there is an "is today" field (also an "...is yesterday" option should you need it)

  • 0 in reply to BReddeman

    Thank you for replying. I see those two options. However, I actually need the filter to list sales orders with a ship date BEFORE today, and there doesn't seem to be an obvious way to set that, (besides updating the date each time I need the information).

  • 0 in reply to Michael Kaney

    My apologies, I mis-read that!  Assuming I have read your post question correctly you would like everything that's NOT today OR in the future.

    If that's the case you could try changing the "Filter AND" to "NOT AND"  (Both Conditions) or "NOT OR" (either condition) then "Ship Date is Today."

    That'd filter everything that is not today; that would not however solve for future dates. We can add additional conditions to filter future dates. I'm not sure how effective that'd end up as I haven't tried filtering for future dates myself.

    Hopefully that helps?

*Community Hub is the new name for Sage City