Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Compare 2 dates and output a specific word in a third field

I have a simple nested IF statement that works correctly in Excel, but in translating it to QB, it fails. Excel Formula:   =IF([Date Received] < $E$3, "GW", IF([Date Received] < $E$4, "INVERTER"...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
I suggest that you specifically test for null with IsNull([date field]) to handle that situation and deal with specifying he result you want.

IF(
IsNull([Date Received],"say this",
IsNull([Recloser Date], "say that",
[Date Received] < [Recloser Date], "GW", 
[Date Received] > [Recloser Date], "GOOD" )