Forum Discussion

amandabus21's avatar
amandabus21
Helper V
3 years ago

Months Between

How can I find the months between the Calendar Day and today.    This should be for each Material.Material level  01 key.    
FreemanZ's avatar
FreemanZ
Super User
3 years ago

hi amandabus21 

try to add a calculated column like:
Months =
DATEDIFF([Calendar Day], TODAY(), MONTH)
amandabus21's avatar
amandabus21
Helper V
3 years ago

Thank you, is there a way I could get it down to the DayNumberOfMonth of the Current Date?

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    hi amandabus21 

    do you mean a column like:

    DAY([Calendar Day])

    • amandabus21's avatar
      amandabus21
      Helper V
      3 years ago

      No for example it would be 1 month if it was exactly the day

       

      So 3/21/2023 would be 1 month (from today 4/21/23)

       

      But 3/30/23 shouldnt be 1 month because today is (4/21/23) and technically a full month hasnt passed.

       

      I used the first formula you provided and named Age Buckets.