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?
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
6 years ago
You can convert work date field types to normal date fields within a different formula field in a formula using

ToDate([My Work Date field])

Then use normal date arithmetic in formuals.