Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
7 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
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
5 years ago
Wow, that worked. I can't thank you enough. Any chance I could add a color to the field? green for on time and red for late?