My Formula below is giving error on line 2, it says String is required here.
I am using 2 tables to get my data, command and command1.

Please Please help me.


IIF ({command.date_app_entered} <> #1/1/1900# and {Command_1.date_app_recvd} <> #1/1/1900# and
    {command.date_qt_mailed} = #1/1/1900# and {command.date_gen_letter} = #1/1/1900# and
    {command.date_declined} = #1/1/1900# , "YES" ,  "NO")

IIF ({command.date_app_entered} <> #1/1/1900# and {command.date_app_recvd} <> #1/1/1900# and
    {command.date_qt_mailed} = #1/1/1900# and {command.date_gen_letter} = #1/1/1900# and
    {command.date_declined} = #1/1/1900# , "YES" ,  "NO")

Date app Received is a VarChar in Database

No I am not looking for nulls, I am looking for value.
I
IF ({command.date_app_entered} <> #1/1/1900# and todate({command.date_app_recvd}) <> #1/1/1900# and
    {command.date_qt_mailed} = #1/1/1900# and {command.date_gen_letter} = #1/1/1900# and
    {command.date_declined} = #1/1/1900# , "YES" ,  "NO")

I am getting error at todate (a number, boolean, date or string is expected here)

If I do C date, I get date as 1994-03-30 00:00:00

This is how my date is coming and I cannot even change the format. I don't see date and time format TAB to change it.

I want to see date as 02/04/2009

I have an existing report, which is using one field called data_app_recvd and all other fields from table name Dateinfo

I have to change the report database, I can do that but now the field data_app_recvd. I have to get from another table called policy.

I did create a Command to do the Join

select
d.ISN,
d.name_ins,
d.lifecycle_status,
d.date_app_entered,
p.date_app_recvd,
d.date_qt_mailed,
d.date_gen_letter,
d.date_declined,
d.uwinits,
d.bornum

from DateInfo D,
policy P

where
d.OBJECT_NUM  = p.POLICY_NUM


OLD formula I need to update is

IIF ({date_info.date_app_entered} <> #1/1/1900# and {date_info.date_app_recvd} <> #1/1/1900# and
    {date_info.date_qt_mailed} = #1/1/1900# and {date_info.date_gen_letter} = #1/1/1900# and
    {date_info.date_declined} = #1/1/1900# , "YES" ,  "NO")

My Updated formula to get data:

IIF ({command.date_app_entered} <> #1/1/1900# and cdate({command.date_app_recvd}) <> #1/1/1900# and
    {command.date_qt_mailed} = #1/1/1900# and {command.date_gen_letter} = #1/1/1900# and
    {command.date_declined} = #1/1/1900# , "YES" ,  "NO")