G
Guest
I have three fields that I want to base a criteria on:
Received Date/Time, Date Approved and Date Rejected
The way I wrote the criteria is as follow:
LagTime: [Received Date/Time] - [Date Approve]
This works if there is a date in the "Date Approve" field but if there isn't
a date in the field nothing comes back. What I would like for it to do is
pull the date from the "Date Rejected" field and calculate the lagtime from
there.
What do I need to add to my expression to do this?
Received Date/Time, Date Approved and Date Rejected
The way I wrote the criteria is as follow:
LagTime: [Received Date/Time] - [Date Approve]
This works if there is a date in the "Date Approve" field but if there isn't
a date in the field nothing comes back. What I would like for it to do is
pull the date from the "Date Rejected" field and calculate the lagtime from
there.
What do I need to add to my expression to do this?