AnsweredAssumed Answered

Days Remaining Convert to Months and Days

Question asked by themactech. on Oct 1, 2014
Latest reply on Oct 1, 2014 by themactech.


Days Remaining Convert to Months and Days


My apologies if this is in another thread. I searched and found numerous references to Age calculations but I don't think it's related. I have a hard time wrapping my head around date/time calculations.


I have two fields

Inspection Date (date field)

Next Inspection Date (calculation fields) which is "Inspection Date * 900"
Basically 30 months from the current inspection date.

Days Left (calculation field) which is " Next Inspection Date - Get(CurrentDate)"
that should give me how many days are remaining before the Next Inspection Date is due.

I would like to display that as Months and Days

12 months 20 days and if it gets below a year then just show the days.

Seems like it should be a simple thing. My brain just can't relate to date and time conversions ;)