Hi all,
I'm new to the forum :-)
I'm working on a query that will allow me to put the oldest letters we are working on, on the top.
We receive a request from our client and once we start working on the request, we fill in the field [Start_Date]. If we have some questions to our client, we send an email and put the sent date in the field [date_sent_question_client]. When we receive the answer, we fill in the field [date_answer_from_client]
As you can see from the below, the calculation of the days passed are almost OK, but since the sending and receiving answer was 2 days in the first letter, those 2 days should be descounted and instead of 10 it should be 8:
[Start_Date] [date_sent_question_client] [date_answer_from_client] Expr1: Date()-[Start_Date] Expr2: [date_answer_from_client]-[date_sent_question_client] Expr3: [Expr1]-[Expr2] 30/06/2015 30/06/2015 02/07/2015 10 2 8 30/06/2015 10 02/07/2015 8 02/07/2015 8 02/07/2015 8
Any clue how it could be solved?
Greetings.