Recent content by pravy

Thanks for the prompt reply but using this I get an error as "this expression.. cannot be used in a calculated column" . Well is it ok to use Now function in a calculated field?

I have the below formula in excel that needs to work in a new calculated field of Access 2010. =IF((ISBLANK(Mydate)),IF(Deadline date>TODAY(),"Not sent (Deadline approaching)", "Not sent (Past due)"),IF(Mydate<=Deadline date,"On time","Not on time")) Kindly help.