Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

convert number to date in custom report

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

Postby Erik » Sun Jan 28, 2018 7:34 am

In my custom report, I want to add a column with prices in the past. For instance 90 days ago, like so:

EVAL( ENDDAYS()-90,ENDDAYS()-90 ,End_NAV )

In the column next to it, I would like to list the corresponding date. So I tried:

EVAL( ENDDAYS()-90,ENDDAYS()-90 ,Last_price )

..but I don't know how to convert the calculated number back to a date-format. Is that possible?

Regards,
Erik
Erik
 
Posts: 39
Joined: Mon Nov 27, 2017 8:20 am

Postby Mark » Sun Jan 28, 2018 11:31 am

Hi Erik,

Sorry, this isn't possible with this feature currently. You can only get a number value out of a user-defined field, not a date. We can consider making this improvement in a future update.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11253
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ

Postby Erik » Sun Jan 28, 2018 12:34 pm

Yes, a function that does that would be a great addition. Thank you.
Erik
 
Posts: 39
Joined: Mon Nov 27, 2017 8:20 am


Return to Reports

Who is online

Users browsing this forum: No registered users and 7 guests

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