convert number to date in custom report

[Erik]

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

[Mark]

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.

[Erik]

Yes, a function that does that would be a great addition. Thank you.