Hi Wendy, I'm assuming you have a table where each record represents an email, and your automation triggers off of a new record being created in this table?

If so, perhaps you could try the following:

1. Add a new formula field called "Now" with the formula "NOW()`
2. Add a new Date field called "Last date email sent"
3. In the automation that sends the email, add another step to update the triggering record, specifically to place the value of the "Now" field into the "Last date email sent" field

Hi,

I am looking for the same sort of solution, but this doesn't seem to be working for me. Has something changed in this space since 2022 when you posted this suggestion?

Nope, nothing's changed.  Try setting up your automation like this:

Link to base

Man I feel so stupid - it still doesnt work, but a different error this time.

When I look up Could not convert string to date help I just appear to get more confused. I thought it might have been because I have set date format to European, so I changed that and it still throws an error:

Where it says Record ID in the Input for testing, is there a reason is shows random letters/numbers as opposed to the name of the record? The email is getting sent as it should be (testing one comes to me).

Hmm I think your formula field isn't set up right; it should look like this: 

Try duplicating the base I linked above and checking what the differences are between the automation I set up and yours!

Hmm I think your formula field isn't set up right; it should look like this: 

Try duplicating the base I linked above and checking what the differences are between the automation I set up and yours!

Ah! I fixed my formula! I had totally copied your suggestion and used the quotation marks when I copied it so it was just displaying the text! and that why the formula wasnt throwing an error either! Oh man - what a week I am having!