Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Days Between Formula

Questions on using, creating, or understanding data in Fund Manager reports.

Postby AssetHound » Fri Jan 06, 2023 4:28 pm

I'd like to create an IF statement that checks for the number of days between the starting and ending report dates, and calculate an expression based on whether or not the report period length is over/under a fixed number of days. The usage of EVAL and other days functions aren't clear to me, however. Thanks for any help.
AssetHound
 
Posts: 57
Joined: Sun Sep 11, 2011 3:14 pm

Postby Mark » Fri Jan 06, 2023 5:07 pm

Hi AssetHound,

You can use something like:

IF((ENDDAYS()-STARTDAYS()) > 30, 1, 0)

so, if the date range of the report is more than 30 days, it will return 1, and if not, it will return 0. You can replace 1 and 0 with your desired expressions, and you can of course change 30 to whatever you wan.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 10644
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to Reports

Who is online

Users browsing this forum: No registered users and 3 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2023 Beiley Software, Inc. All rights reserved.