0 Replies Latest reply: Jun 12, 2013 10:19 PM by James.zhang RSS

    What is your way to store a date in HFM?

    James.zhang

      In financial reporting, date is also very important information at like operating lease commitement, Bank Loan, etc.

       

      Just want to know, what is your way to store this?

       

      To me, it seems can only be store at cell text. But as far as I know, there is no way to control the data quality for cell text. In this way, I am afraid some user will use mm/dd/yyyy format, some will use dd/mm/yyyy or yyyy/mm/dd format.

       

      Would you mind to let me know how you handle about this?

       

      Thanks.

       

      James