Calculated field can not be formated to MediumDate

F

Frank Situmorang

Hello,

This calculated field: DateSelect: IIf([Selec]=True,Date(),"") in my query
can not be formatted to Medium date.

I appreciate anyone helps on this

Thanks a lot
 
A

Allen Browne

The problem is that the alternative you entered is Text. A zero-length
string is not a valid date. Therefore Access has to treat the field as text.

Try Null instead:
DateSelect: IIf([Selec],Date(),Null)
 
F

Frank Situmorang

Thanks Allan it works well now, you are awesome
--
H. Frank Situmorang


Allen Browne said:
The problem is that the alternative you entered is Text. A zero-length
string is not a valid date. Therefore Access has to treat the field as text.

Try Null instead:
DateSelect: IIf([Selec],Date(),Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Frank Situmorang said:
This calculated field: DateSelect: IIf([Selec]=True,Date(),"") in my query
can not be formatted to Medium date.

I appreciate anyone helps on this

Thanks a lot
Click to expand...
Click to expand...
 
Top