Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Last Modified Date Formula for a specific content

Topic Labels: Formulas
Solved
Jump to Solution
5225 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Lucas_Vieira
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi everyone.

I have a base where there are some status to define where are the content that are being created. But, I have to know the date and time when the status “Completed” was added. Do you know how to do this?

1 Solution

Accepted Solutions

Ah, I understand, my bad. Maybe this will work.

Keeping the same table as above, you could create a formula field that shows the date/time from the last modified field but only if the status of that project is complete.

The formula and a picture of the table where the formula is placed in the “Date/Time Complete” field:

if( Status = "Complete" , DATETIME_FORMAT({Date Complete} , 'M/D/YYYY'),"")

Last Modified Changed

Here’s a helpful link that lists what you can use in the DATETIME_FORMAT Function (where I used ‘M/D/YYYY’) :

Hopefully I was able to get what you needed this time. Let me know if you had any other quesitons/issues.

See Solution in Thread

4 Replies 4
Sam_Cederwall
7 - App Architect
7 - App Architect

Hello Lucas,

There’s a field in Airtable called Last Modified Time as shown below:

Last Modified Field

You are able to specify when this field shows an updated date/time by choosing the specific fields button and it will look something like this:

Last Modified Field Specific Fields

This way, when your status is changed, the last modified time will also change, like so:

Last Modified Changed

If you don’t want to use a single select to mark complete, maybe you could use a checkbox field and as soon as that is filled out, the field gets updated in the same way.

Hopefully I was able to capture what you needed. Good luck!

Hi Sam. Thanks for the reponse. I was using the last modified field, but it computes every modification in this field. I want it computes only if the word “Complete” is selected.

Here’s an exemple:

Status: In progress | Date complete: Blank
Status: Complete | Date complete: 5/6/2020

If there’s some solution to this, I’d be grateful.

Ah, I understand, my bad. Maybe this will work.

Keeping the same table as above, you could create a formula field that shows the date/time from the last modified field but only if the status of that project is complete.

The formula and a picture of the table where the formula is placed in the “Date/Time Complete” field:

if( Status = "Complete" , DATETIME_FORMAT({Date Complete} , 'M/D/YYYY'),"")

Last Modified Changed

Here’s a helpful link that lists what you can use in the DATETIME_FORMAT Function (where I used ‘M/D/YYYY’) :

Hopefully I was able to get what you needed this time. Let me know if you had any other quesitons/issues.

Thanks a lot, Sam! It helped and it works perfectly.