I'm working on a report and Apptio and would really appreciate some help with my code.  Can you tell me how to adjust the code below so that if the "Projects Master Data.Baseline Date" is more than 3 years old, it will return blank (instead of the date).  Thank you in advance.

<div
class="appsText"
align="left"
style="padding:0px 0px 0px 0px;
font-size:18px;color:#004C76;">
<b><%=DateFormat(Projects Master Data.Baseline Date,”MM/dd/yyyy”)%></b>
</br>

Hi @Doug Copeland,

Try this:

<div
class="appsText"
align="left"
style="padding:0px 0px 0px 0px;
font-size:18px;color:#004C76;">
<b><%=If(Months(CurrentDate("MM/dd/yyyy"))-Months(DateFormat(Projects Master Data.Baseline Date,”MM/dd/yyyy”))>36,"",DateFormat(Projects Master Data.Baseline Date,”MM/dd/yyyy”))<%></b>
</br>

I'm assuming by the phrase 'is more than three years old' I'm assuming  Baseline Date field is more than three years old when compared to todays date. I haven't tested the code, but another assumption I have made is that Apptio will work with functions embedded into other functions e.g. Months(DateFormat(xxxx,"####")) etc.

Regards,

Chris

Chris,

Thanks for taking time to reply.  The code looks like it should work, but I get the following error.

@Christopher Wilson

Hi Doug,

Apologies, typo when copying the code... try this :

<div
class="appsText"
align="left"
style="padding:0px 0px 0px 0px;
font-size:18px;color:#004C76;">
<b><%=If(Months(CurrentDate("MM/dd/yyyy"))-Months(DateFormat(Projects Master Data.Baseline Date,”MM/dd/yyyy”))>36,"",DateFormat(Projects Master Data.Baseline Date,”MM/dd/yyyy”))%></b>
</br>

NOTE remove the '<' from the original code below

<div
class="appsText"
align="left"
style="padding:0px 0px 0px 0px;
font-size:18px;color:#004C76;">
<b><%=If(Months(CurrentDate("MM/dd/yyyy"))-Months(DateFormat(Projects Master Data.Baseline Date,”MM/dd/yyyy”))>36,"",DateFormat(Projects Master Data.Baseline Date,”MM/dd/yyyy”))<%></b>
</br>

Chris,

Seemed to work when I initially executed the code, but then game me the error below.  Maybe a limitation within Apptio?

@Christopher Wilson

Hi Doug,

I've been testing the if statement in Apptio, and it fails badly if the data in your Master Data.Baseline Date is not recognized as a date. can you provide some example Baseline Date data? For example if your Baseline Date data is in following format yyyyMMdd (ISO format) e.g 20090101 doesn't seem to work, but if its 01/01/2009 it does work.

Thanks,

Chris

Hi

You could use the Value() to assess the Boolean value in the IF statement : If(Value(calcul)>36,"","")

Rachid