Empty filed #error

G

Gerrym

In creating a make-table query I am converting numbers to
dates in two fields. One of the fields (Field1) will
always have date while the other field (Field2) may not.
How can I test for an empty field2 in my date conversion
expression and use the contents of Field1 for Field2 when
Field2 is empty.

This is the expression I am Using.

Expr2: DateValue(Right([IETEST_DSPUSRPRF]![UPPSOD],2)
+"/"+Mid([IETEST_DSPUSRPRF]![UPPSOD],3,2)+"/"+Left
([IETEST_DSPUSRPRF]![UPPSOD],2))
 
Top