E ECEK Registered User. Local time Today, 11:02 Joined Dec 19, 2012 Messages 717 Dec 7, 2017 #1 When both or one date is not available my field says #Type! How to I get it to disregard (Null) where a calc is not available? =fNetWorkdays([dr_date],[dic_date]) & " days"
When both or one date is not available my field says #Type! How to I get it to disregard (Null) where a calc is not available? =fNetWorkdays([dr_date],[dic_date]) & " days"
E ECEK Registered User. Local time Today, 11:02 Joined Dec 19, 2012 Messages 717 Dec 7, 2017 #2 My solution: =IIf(IsNull([dr_date])," ",IIf(IsNull([dic_date])," ",fNetWorkdays([dr_date],[dic_date]) & " days")) There must be an easier way though?
My solution: =IIf(IsNull([dr_date])," ",IIf(IsNull([dic_date])," ",fNetWorkdays([dr_date],[dic_date]) & " days")) There must be an easier way though?
Minty AWF VIP Local time Today, 11:02 Joined Jul 26, 2013 Messages 10,678 Dec 7, 2017 #3 I would possibly build the function to return a string like "3 Days" or "1 Day" or "" if there weren't valid dates, or build a function around the core function to do that.
I would possibly build the function to return a string like "3 Days" or "1 Day" or "" if there weren't valid dates, or build a function around the core function to do that.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 19:02 Joined May 7, 2009 Messages 20,704 Dec 7, 2017 #4 you got the simpliest.
