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 create two new fields but you don't have to.

for example

WeekdaySub(ToDate([my work date field 1]), ToDate([my work date field 2]))