iif statement - return a formatted date field

[tennis2600]

Hi Everyone,

I am trying to use an iif statement that will return a date formatted as a date. Currently I am not sure what format the field is being returned in, but it looks like text, not an actual date. My iif statement is comparing a field in a given table and says if that field is L then use the date field from table A, but if it isn't L then use the date field from table B. Both Table A and B fields are date fields. Any ideas how I can get the query to format the iif statment?

Thanks for all your help!

Mike

[pbaldy]

Might help to see your statement.

Offhand, the CDate() function may work. If you're using the Format() function, it does return a string. I'd do the formatting on the form or report.

[tennis2600]

Thanks for your help!!!

this is my expression now
PREV_OP_END_DATE: IIf([V_JOB_OPERATIONS]![LMO]="L",CDate(([WORKORDER_OPEN_OPS_TABLE]![END_DATE])),CDate([MATERIAL ON ORDER FOR SCHEDULING QUERY]![DUE_DATE_L]))

It is working except I get the "#Error" when the filed is null. Any ideas on how I can get it to stay null?

Might help to see your statement.

Offhand, the CDate() function may work. If you're using the Format() function, it does return a string. I'd do the formatting on the form or report.