Calculate HC in LIM for Mid-Month Start
Not out of the box, right now.
You have to use a custom event handler to calculate additional fields as follows:
- Start Date - normal register field
- End Date - normal register field
- S_Day - calculate via custom event handler to then be used in formulas
- S_Month - calculate via custom event handler to then be used in formulas
- S_Year - calculate via custom event handler to then be used in formulas
- E_Day - calculate via custom event handler to then be used in formulas
- E_Month - calculate via custom event handler to then be used in formulas
- E_Year - calculate via custom event handler to then be used in formulas
Once you have the start date and end date parsed out, you can then take the day in the month for whichever is needed (S_DAY or E_Day) and bump it against a cube driver of days in month to get the partial or mid-month calculation needed.
These fields do not do that:
As an enhancement request I think the following Functions are needed out-of-the-box:
- Day(Date)
- Month(Date)
- Year(Date)
Where Day(Date) of 3/15/2026 would return 15 and Month(Date) of 3/15/2026 would return 3 and Year(DAte) of 3/15/2026 would return 2026 as then you would have the pieces needed to do mid-month or partial month calculations.
Right now the work around is to do via a custom event handler in LIM.
