By using this website, you agree to our Terms of Use (click here)
I am trying to calculate a date difference [start date {an attribute} with today's date, in a generic inquiry that shows year(s) and month(s). We would like to know how long a company has been a customer, i.e. 2 yrs and 2 mths....from what I can tell in a GI you can either do 'year(s)' or 'month(s)'...using the year formula it seems to round the year up to 3 years and using months I get 26 months (which is great, but just to hard to convert to year, month in ones' head) if I divide the formula by 12, I get 3 instead of 2.166).
Thanks in advance for the help.
Hi @britt-steinhardt, try these:
Years:
=CINT(DateDiff( 'M', [START DATE], Today())/12)
Months:
=DateDiff( 'M', [START DATE], Today())%12
Thanks - that worked great as separate columns/calculations, is it possible to combine the two formulas so that the result looks something like this - 1 yr 2 mths, we would ultimate like to highlight the rows that show 6 months, 5 years, 10 years...etc.
This should work:
=IIF(DateDiff( 'D', [Batch.DateEntered], TODAY()) < 30, 'New' ,IIF(CINT(DateDiff( 'M', [Batch.DateEntered], TODAY())/12) < 1,'',CSTR(CINT(DateDiff( 'M', [Batch.DateEntered], TODAY())/12)) + 'yr ') + IIF(DateDiff( 'M', [Batch.DateEntered], TODAY())%12=0,'',CSTR(DateDiff( 'M', [Batch.DateEntered], TODAY())%12)+ ' mth'))
That worked perfectly!!....thanks so much for your help, greatly appreciated.
Dear Sir ;
when i subtract enddate - today() its count wrong days can u guide me
my formula : DateDiff('d',(TODAY()),( [AMProdOper.EndDate]))
Looks correct to me.
any one guide me this is show wrong no of days