HFM v11.1.2.3 - Calc Manager question
Hello All
Is it possible to calculate the numbers of days difference based on two dates. I am trying to use the @DATEDIFF function.
The scenario is as follows:
The user wants to capture a start date and a end date in the webform. The format of the date is DD-MM-YYYY as entered by the user in the excel spec provided. The user is flexible to adopt a different format in order to suit how HFM needs it to be.
Three accounts have been created in the metadata (Start Date, End Date and Days difference). Days difference account is a calculated account.