Formulas

[MaRSMAN]

YrsMarried:
Abs(DateDiff("yyyy",[MarriageDate],Date())+(Format(Date(),"mmdd")<Format([MarriageDate],"mmdd")))

The above formula works fine I just need to include an IIF in it.
I need the formula to also calculate the YrsMarried when the MarriagedEnded
fld is updated to 1/31/2005 The IIF part of the formula
MarriageDate MarriageEnded
5/31/1975 Yrs Married 33
When Updated 1/31/2005 YrsMarried 30
Thanks

 

[Allen Browne]

Replace Date() with:
Nz([MarriageEnded], Date())

 

[MaRSMAN]

Thanks Worked perfect just had to add a closing Parenecy at the end of the
formula
Wish I was as smart as you

Replace Date() with:
Nz([MarriageEnded], Date())

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

YrsMarried:
Abs(DateDiff("yyyy",[MarriageDate],Date())+(Format(Date(),"mmdd")<Format([MarriageDate],"mmdd")))

The above formula works fine I just need to include an IIF in it.
I need the formula to also calculate the YrsMarried when the
MarriagedEnded
fld is updated to 1/31/2005 The IIF part of the formula
MarriageDate MarriageEnded
5/31/1975 Yrs Married 33
When Updated 1/31/2005 YrsMarried 30
Thanks