Calculated field can not be formated to MediumDate

  • Thread starter Thread starter Frank Situmorang
  • Start date Start date
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
 
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)
 
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...
 
Back
Top