Age Calculatre if End Date is missing/Blank it should take today date

[ijaz8883]

Hi Respected experts!!
I am facing a problem
I have a form in which I want to calculate age and I am using said formula:
=fAge([StartDate],[EndDate])


But I want to say that If I have blank [EndDate] it should automaticly take it as date()as [StartDate] and [EndDate)
Sometime I have no EndDate then I want that it may calculate it to todate as dd/mmm/yy
Thanks in Advance

[Bob Fitz]

Maybe:
=fAge([StartDate],Nz(dDate],Date())

[ijaz8883]

Maybe:
=fAge([StartDate],Nz(dDate],Date())

=fAge([StartDate],[EndDate])
=fAge([StartDate],[dDate])
I have check twice but not working. Its shows error if the field is blank

[moke123]

It would probably help to see the code behind fAge()

What format are your dates in? You may need to US date format.

[xps35]

Maybe Bob made a typo.
Try =fAge([StartDate],[Nz(EndDate], Date()))

[Bob Fitz]

Maybe Bob made a typo.

Quite right Peter. I let a bracket off when I copy/paste it rom the file I tested in. Should have been:
=fAge([StartDate],Nz([EndDate], Date()))

[ijaz8883]

Quite right Peter. I let a bracket off when I copy/paste it rom the file I tested in. Should have been:
=fAge([StartDate],Nz([EndDate], Date()))

Thanks a lot its worked perfect

[ijaz8883]

Maybe Bob made a typo.
Try =fAge([StartDate],[Nz(EndDate], Date()))

Thanks a lot its worked after little bracket change
=fAge([StartDate],Nz([EndDate], Date()))

[Bob Fitz]

Thanks a lot its worked perfect

Glad you have it working