What is your way to store a date in HFM?

 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