I have an expression that is currently working in the format of x year(s), x month(s), x day(s), but if the result does not have a value in in each category I want it NOT to display that group. Such as if the return is 5 months and 16 days, I want it not to display the years segment. Below is the code I'm using. I've tried adding ISNULL(xxxx) at the beginning but its giving me an error. Any help would be aprreciated!
TIR Date Calc: DateDiff("m",[TIR Date],Date())\12 & "year(s), " & DateDiff("m",[TIR Date],Date()) Mod 12 & "month(s), " & DateDiff("d",[TIR Date],Date()) Mod 12 & "day(s)"
TIR Date Calc: DateDiff("m",[TIR Date],Date())\12 & "year(s), " & DateDiff("m",[TIR Date],Date()) Mod 12 & "month(s), " & DateDiff("d",[TIR Date],Date()) Mod 12 & "day(s)"