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"...
AndrewLandry's avatar
AndrewLandry
Qrew Trainee
6 years ago
I know it has been some time since this thread but I'm having a similar problem specifically with workdates. any ideas?
AndrewLandry's avatar
AndrewLandry
Qrew Trainee
6 years ago
ah, I see. So I need to create 2 new fields to convert the work date fields? Wonder why QB doesnt allow operators on Work date fields. thanks for your help