I have a Date/Time field which I call MeetingDate. When I do a report based on the query in which there's MeetingDate field, there's some empty values of the field and I want to put text "N.A" in it. In the query I've created a new field which I call "StrMeetingDate" which I converted to string as below:
StrMeetingDate: IIf(IsNull(CStr(Format([MeetingDate],"dd-mm-yyyy"))),"-",CStr(Format([MeetingDate],"dd-mm-yyyy")))
When I run the query, I still got empty value. What's wrong with my condition? Or how can I do it?
Thanks
StrMeetingDate: IIf(IsNull(CStr(Format([MeetingDate],"dd-mm-yyyy"))),"-",CStr(Format([MeetingDate],"dd-mm-yyyy")))
When I run the query, I still got empty value. What's wrong with my condition? Or how can I do it?
Thanks