Skip to main content
Solved

Converting a Date field to a Last Modified Date field without losing past dates

  • January 9, 2023
  • 4 replies
  • 68 views
T
Forum|alt.badge.img+7

I have a "date paid" date field that I've realized I could automate better by transitioning it to a checkmark (paid?) and a last modified date field. But when I do that I lose all the paid dates paid (which impacts other calculations throughout my table). Is there any way to get around this?

Best answer by Universus

Hey Tobin_Perry,

I'd suggest you create a formula field with:

IF ( {Field_with your dates} , {Field_with your dates}, LAST_MODIFIED_TIME ( {Name of the field with checkbox} ) )

This will check if you have a date where you have been writing dates,
If there is, it writes it.
If not, it will use the last time you checked the checkbox of the new field you want to create.

Let me know if this answers your need 🙂

Cheers!
Julien


@Tobin_Perry 

Here is a video response I got from the support of Airtable. (I was having a similar need than you).

https://share.support.airtable.com/bLu5RL0Q 

Hope it helps 😇

    4 replies

    S
    Forum|alt.badge.img+11
    • Steve_Haysom
    • Inspiring
    • January 9, 2023

    Hi Tobin

    Would it be easier to keep the date paid field and add a button that updates the field to today's date using a script, or a checkbox that updates it using an automation?

    U
    Forum|alt.badge.img+3
    • Universus
    • New Participant
    • January 10, 2023

    Hey Tobin_Perry,

    I'd suggest you create a formula field with:

    IF ( {Field_with your dates} , {Field_with your dates}, LAST_MODIFIED_TIME ( {Name of the field with checkbox} ) )

    This will check if you have a date where you have been writing dates,
    If there is, it writes it.
    If not, it will use the last time you checked the checkbox of the new field you want to create.

    Let me know if this answers your need 🙂

    Cheers!
    Julien

    U
    Forum|alt.badge.img+3
    • Universus
    • New Participant
    • Answer
    • January 16, 2023

    Hey Tobin_Perry,

    I'd suggest you create a formula field with:

    IF ( {Field_with your dates} , {Field_with your dates}, LAST_MODIFIED_TIME ( {Name of the field with checkbox} ) )

    This will check if you have a date where you have been writing dates,
    If there is, it writes it.
    If not, it will use the last time you checked the checkbox of the new field you want to create.

    Let me know if this answers your need 🙂

    Cheers!
    Julien


    @Tobin_Perry 

    Here is a video response I got from the support of Airtable. (I was having a similar need than you).

    https://share.support.airtable.com/bLu5RL0Q 

    Hope it helps 😇

    T
    Forum|alt.badge.img+7
    • Tobin_Perry
    • Author
    • Known Participant
    • January 16, 2023

    @Tobin_Perry 

    Here is a video response I got from the support of Airtable. (I was having a similar need than you).

    https://share.support.airtable.com/bLu5RL0Q 

    Hope it helps 😇


    Thanks that worked!

    Terms & ConditionsAccessibility statement