In my report,I need to set the dates before 1/1/2017 as "Expire" instead of ?/?/2017, and after that time the filed date but in dd-mmm-yy format.
for this reason i have to write a query and set an "IIF" function as you can see in attachment, but problem is output of IIF function. It is text it is not Date! so Msaccess can not sort it or do any format style on it! I searched and found CDate function and half of my problem solved but when this function input is "Expire" the output is #Error !!!
Plz show me the way. thanks