Can anyone tell me what this formula will do? IF(CLEARTIME(Entry Date)>=CLEARTIME(Planned Completion Date-2w),"Unplanned","Planned") Cliff De Jong IEHP
Hi Cliff, This would be for a calculated field which compares the Entry Date with the Planned Completion Date. If the Entry Date is within 2 weeks before the Planned Completion Date, then the field will be populated with the word 'Unplanned', and otherwise it will be 'Planned'. Regards, David Cornwell
