IBM Apptio

Apptio

A place for Apptio product users to learn, connect, share and grow together.


#Aspera
#Apptio
#Automation
 View Only
Back to discussions
Expand all | Collapse all

What is an acceptable date format in Apptio?

  • 1.  What is an acceptable date format in Apptio?

    Posted Mon May 08, 2017 02:18 PM

    What date format does Apptio accept while uploading data from a CSV file?

     

    I have tried using the formats MM/DD/YYYY, DD/MM/YYYY, DD MMM YYYY, and various others, but Apptio always tries to import them as plain text instead of as a date. What format do I need to use to import a string as a date object?









    #CostingStandard(CT-Foundation)


  • 2.  Re: What is an acceptable date format in Apptio?
    Best Answer

    Posted Wed May 10, 2017 04:26 AM

    Hi Jonathan,

     

    the way Apptio handles dates is really a two step process.

     

    During the initial upload Apptio will only distinguish between a Label and a Numeric field. What you then need to do in either your raw file or first transform is to set the type of the column to be Date and to provide the format e.g. DD/mm/yy.

     

     

    If you add the following link after yourdomain.apptio.com/ you will see the help file on the date formats you can use

    biit/webhelp/studio/r11.8.3.5.fcf8c159b734.47910/index.html#../Subsystems/Studio/Content/formulas-and-functions/functions/dateformat.htm?Highlight=date format


    #CostingStandard(CT-Foundation)


Related Content