Carol Nunkovich
  • Female
  • Aurora, IL
  • United States
Share

Carol Nunkovich's Discussions

Date ranges in Sage Intelligence
2 Replies

Hi all,I'm trying to restrict the data in my report to the past 7 days. Possible?Continue

Started this discussion. Last reply by Marius Yung Dec 24, 2018.

 

Carol Nunkovich's Page

Latest Activity

Marius Yung replied to Carol Nunkovich's discussion Date ranges in Sage Intelligence
"add the where in your container statement i.e. Where DATEDIFF(day, SHIPDATE, Getdate()) <7"
Dec 24, 2018
Carol Nunkovich replied to Carol Nunkovich's discussion Date ranges in Sage Intelligence
"figured it out! added an expression to the container, IF(NOW()-SHIPDATE>6,"N","") then brought that field into the pivot table and wrote a macro to sort out the "N"'s"
Dec 21, 2018
Carol Nunkovich posted a discussion

Date ranges in Sage Intelligence

Hi all,I'm trying to restrict the data in my report to the past 7 days. Possible?See More
Dec 21, 2018
Carol Nunkovich is now a member of The Sage Intelligence Community
Aug 8, 2014

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage MAS Intelligence
Website
http://www.importlogistics.com
About Me:
i'm happy :)
How long have you been using the above solution?
3 years
Where did you hear about us?
Other

Comment Wall

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

  • No comments yet!
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

¬© 2019   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service