Writing Invoice Age - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Writing Invoice Age

James Hopkins

3 years ago

Hey Guys, I am trying to figure out the right way to writing the Invoice Age by "Months and Years".

Here's what I got:
InvoiceAgeDays: DateDiff("d",[InvoiceDate],Date())
InvoiceAgeMonths: DateDiff("m",[InvoiceDate],Date())
InvoiceAgeYears: DateDiff("yyyy",[InvoiceDate],Date())

InvoiceAge: [InvoiceAgeMonths] & " mo " & IIf([InvoiceAgeDays]=30,"","d") & ", " & [InvoiceAgeYears] & " yrs." & IIf([InvoiceAgeMonths]=12,"","mo.")

	Adam Schwanz @Reply 3 years ago
`InvoiceAge: InvoiceAgeYear & " Years and " & InvoiceAgeMonths & " Months and " & InvoiceAgeDays & " Days"` Would say something like "5 Years and 2 Months and 14 Days"

	Adam Schwanz @Reply 3 years ago
I don't really know what you're trying to accomplish with the IIF statements

Kevin Robertson @Reply

3 years ago

You don't want 1 day, 1 month and 1 year to show as 1 days, 1 months and 1 years so I would write it like this:

InvoiceAge: InvoiceAgeYear & IIF(InvoiceAgeYear=1," year"," years") & ", " & InvoiceAgeMonths & IIF(InvoiceAgeMonths=1," month"," months") & " and " & InvoiceAgeDays & IIF(InvoiceAgeDays=1," day"," days")

This will give the singular if the value is 1 or the plural if any other value.

	Richard Rost @Reply 3 years ago
Check out HowLong

	James Hopkins OP @Reply 3 years ago
Thanks Guys for your Time and Help....

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View