How can this excel formula be imitated in Access?

[pravy]

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.

 

[namliam]

Reformatted your inline to be more readable and "accessivied" it ( I think)

=IF((ISBLANK(Mydate))
     ,IF(Deadline date>TODAY()
         ,"Not sent (Deadline approaching)"
         , "Not sent (Past due)")
     ,IF(Mydate<=Deadline date
         ,"On time"
         ,"Not on time")
    )



=iIF((ISnull(Mydate))
     ,iIF([Deadline date]>Now()
         , "Not sent (Deadline approaching)"
         , "Not sent (Past due)")
     ,iIF(Mydate<=[Deadline date]
         ,"On time"
         ,"Not on time")
    )

 

[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?

 

[namliam]

Try using =Now() as the source and find out...

It is total air code, but it should be close!

 

[Brianwarnock]

Just looking at the logic and not any wider issues shouldn't you be using Date() rather than Now(), or does the time come into the thinking?

Brian