T
TotallyConfused
I have a form that has 3 date fields. Sent Date, Due Date and RCVD Date. I
have been piecing this together and am not sure if I have what I need. If
this can be condensed? Or expressions in Conditional Formatting be nested.
I would appreciate any help you can provide as I am truly Totally Confused on
this one.
I Currently, have the following:
For Sent date field I have on Click event enters Date() and adds a due date
to the Due Date Field
For Due Date field I have in Conditional Formatting expression is
NZ([RCVDDate]),"")="" turns font red
Due Date field in Conditional Formatting expression is ([RCVD DAte])
Is not Null turns font grey
For RCVD date I have on Click event enters Date()
What I need is:
Sent Date field on Click enters Date() and adds a due date to the Due Date
Field.
For Due Date field I want Due Date to turn red if RCVD Date is Null and Due
Date is past date in Due Date. If there is a date in RCVD Date, then I want
Due Date and Sent Date to be greyed.
have been piecing this together and am not sure if I have what I need. If
this can be condensed? Or expressions in Conditional Formatting be nested.
I would appreciate any help you can provide as I am truly Totally Confused on
this one.
I Currently, have the following:
For Sent date field I have on Click event enters Date() and adds a due date
to the Due Date Field
For Due Date field I have in Conditional Formatting expression is
NZ([RCVDDate]),"")="" turns font red
Due Date field in Conditional Formatting expression is ([RCVD DAte])
Is not Null turns font grey
For RCVD date I have on Click event enters Date()
What I need is:
Sent Date field on Click enters Date() and adds a due date to the Due Date
Field.
For Due Date field I want Due Date to turn red if RCVD Date is Null and Due
Date is past date in Due Date. If there is a date in RCVD Date, then I want
Due Date and Sent Date to be greyed.