Skip to main content

I have three columns:





  1. Email


  2. Sent (Yes/No)


  3. Date (Sent)




I would like to add a fourth col to display the number of days since the email was sent (i.e. Current Date - Date Sent, displayed as Days). How can I write a formula for that?

Use DATETIME_DIFF():







Also, I think you could remove the Sent field, cause you already have that information in Date field: if it is filled, it is send.

Use DATETIME_DIFF():







Also, I think you could remove the Sent field, cause you already have that information in Date field: if it is filled, it is send.


Thank you, managed to get it working. Yes, I agree. Thank you!

Can you provide the solution?

What was your solution here?

I would just do:

TONOW({Date Sent})

Reply


Terms & Conditions