Calculated Field - Problems with IFF Statement. (1 Viewer)

All, needs some help please....I have a table with a calculated field that based on a match from a dropdown list I want the user to manually enter a date else show the date based on two other inputs. I can the expression to work if I specify a date or tell it to do nothing. Neither are what I want. I must be missing something?

What do I replace the date range with or is there another way to express it?

IIf([Treatment Type]="Admitted",#01/01/5050#,[Date Given]+[How Many Days])

Appreciate the help!!

Thanks

Jason

you can't do this with calculated fields in tables. It should be done in a query or form.

calculated fields have limited uses - restricted in what you can calculate, cannot be indexed etc.