Hello,
I have this code: Due: DateDiff("d",Now(),[POSNextPerf]), it works good. I want to take it to the next level. In field POSNextPerf is there is no Date in their I want my formula to return 0. Currently it's blank or Null.
Can this be done?
Hello,
I have this code: Due: DateDiff("d",Now(),[POSNextPerf]), it works good. I want to take it to the next level. In field POSNextPerf is there is no Date in their I want my formula to return 0. Currently it's blank or Null.
Can this be done?
Sure!
Try:
Code:Due: IIf(IsNull([PosNextPerf]),0,DateDiff("d",Now(),[POSNextPerf]))
Perfect that worked. Thank you soo much...