Thread: [Solved] Decimal Places
View Single Post
 
Old 12-21-2018, 01:01 PM
DanMichSr DanMichSr is offline Windows 8 Office 2013
Novice
 
Join Date: Jun 2015
Location: East Millinocket, Maine
Posts: 2
DanMichSr is on a distinguished road
Default

Outlook allows you to define your own fields and they can contain formula. So I used the standard field of BIRTHDAY and created a field for AGE etc. I have views set up for my Children and Grandchildren and wanted to have their age shown. For the age of the child I use the formula.....
IIf([Birthday]<>"None",DateDiff("yyyy",[Birthday],Date())-IIf(DateDiff("d", CDate(Month([Birthday]) & "/" & Day([Birthday]) & "/" & Year(Date())),Date())<0,1,0),"")
That works well but would like it to show 2 decimal places and am working on trying to figure that out.

For my past relatives I used their BIRTHDAY and created a simple formula as
([Death Date] - [Birthday] )/ 365.25
And come up with an answer of 56.223342211 or something like that. I would like to have it give me 56.2 or 56.22
Reply With Quote