KristenCarr
Programmer
I'm using the following IIF statment in an Update query. The idea is to compare 2 dates (short date) in one table and insert a value into a third column in that same table.
It is not giving me errors but is inserting all 'C' values. The table only has 27 rows in it right now so I can easily see the results are incorrect.
IIf(([tblExportOfficeTEST]![date_added]>=[tblExportOfficeTEST]![last_updated]),"C","A"
I've tried the statement w/o the table names and that didn't help. I've used other statments and haven't ever had a problem, could it be related to these fields being DATE types?
It is not giving me errors but is inserting all 'C' values. The table only has 27 rows in it right now so I can easily see the results are incorrect.
IIf(([tblExportOfficeTEST]![date_added]>=[tblExportOfficeTEST]![last_updated]),"C","A"
I've tried the statement w/o the table names and that didn't help. I've used other statments and haven't ever had a problem, could it be related to these fields being DATE types?