Change field format based on condition

[Greg]

On my report I am displaying field with control source:
=IIf([Status]="Closed",[Closed Date],[Last Update]) however I would like to
display
Closed in Short Date format and if condition is false [Last Update] should
be displayed in Short Time format.
How do I set this control source?

Thanks

 

[Steve Schapel]

Greg,

Try it like this:
=IIf([Status]="Closed",Format([Closed Date],"Short Date"),Format([Last
Update],"Short Time"))