Help

Use a Formula to Count Days Since Date (Event)

6542 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Say-Chi
4 - Data Explorer
4 - Data Explorer

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?

4 Replies 4

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!

David_Andoh
4 - Data Explorer
4 - Data Explorer

Can you provide the solution?

David_Andoh
4 - Data Explorer
4 - Data Explorer

What was your solution here?