I
Indu Sehgal
Hi
Does anybody know how to calculate an age of product where you enter the date when product was installed and will calculate the age of the product automatically. I did try using this:
IIf([DateInstalled]<>"None",DateDiff("yyyy",[DateInstalled],Date())-IIf(DateDiff("d",CDate(Month([DateInstalled]) & "/" & Day([DateInstalled]) & "/" & Year(Date())),Date())<0,1,0),""),
which is similar to the birthday age calculation and that is fine but I keep on getting a Microsoft Office Outlook message
"Create the "person's name of the contact Birthday" event in your personal Calendar?", Is there a way not to have this message popping up when saving the item. Help Hep, please. Thank you
Ind
Does anybody know how to calculate an age of product where you enter the date when product was installed and will calculate the age of the product automatically. I did try using this:
IIf([DateInstalled]<>"None",DateDiff("yyyy",[DateInstalled],Date())-IIf(DateDiff("d",CDate(Month([DateInstalled]) & "/" & Day([DateInstalled]) & "/" & Year(Date())),Date())<0,1,0),""),
which is similar to the birthday age calculation and that is fine but I keep on getting a Microsoft Office Outlook message
"Create the "person's name of the contact Birthday" event in your personal Calendar?", Is there a way not to have this message popping up when saving the item. Help Hep, please. Thank you
Ind