Forum Discussion

robhel's avatar
robhel
Icon for Helper I rankHelper I
7 years ago
Solved

Year Month Calculation on TODAY ()

Hello Guru's   Looking for your expert advice on how to achieve the following scenario of calculating the number of Year’s & Months from TODAY() until next lot of Long Service Leave (LSL) will be a...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    robhel ,

     

    Try to change it as follows.

        CONCATENATE (
        CONCATENATE ( Years, "." ),
        MOD ( Months - ( Years * 12 ) + 12, 12 )
    )
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Please explain how the answer is 0.6, 0.4, 4.10, 9.10 etc?

robhel's avatar
robhel
Icon for Helper I rankHelper I
7 years ago

Thanks for response & in answer to your question, the result is based on TODAY less Commncement MMYY = number of months or years until next allocation of LSL, example

 

TODAY 27/04/2019 - 12/01/2022 Commencement Date (= 12/01/2012 + 10y) = 2years & 9Mths until LSL

TODAY 27/04/2019 - 29/10/2019 Commencement DDMM & Current Year (29/10/1979 to 29/10/2019) = .6 mths until next LSL days

 

Hope this answer your question

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    robhel ,

     

    Try to change it as follows.

        CONCATENATE (
        CONCATENATE ( Years, "." ),
        MOD ( Months - ( Years * 12 ) + 12, 12 )
    )