Link to home
Start Free TrialLog in
Avatar of Isaac
IsaacFlag for United States of America

asked on

Fiscal Year data

I need to show  all log records over 30 days in the fiscal year. (Once a year at the end of the fiscal year)

Any help would be appreciated.  Below is my list.

Though this is SharePoint 2010, the actual list I am to apply this to is SharePoint 2007.  Just testing in 2010.

http://isaac.issharepoint.com/Lists/Log/Log%20View.aspx
Avatar of QPR
QPR
Flag of New Zealand image

You can have a view that shows between 2 dates where days > 30.
Not sure about only show it once a year but you could create an alert based on that view (where something changes that changes a view) and then the alert would contain a link to that view.

View filter
fiscalYear between dd/mm/yyyy and dd/mm/yyyy
AND
LogRecords > 30
ASKER CERTIFIED SOLUTION
Avatar of Isaac
Isaac
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Isaac

ASKER

Solved