Jan 31, 2023 06:02 AM
I want to use formula TODAY() BUT I Don't want that it will automatically change with each passing day. I need that the original date that was created, will stay the same.
Is there another formula that can do it?
Jan 31, 2023 06:41 AM - edited Jan 31, 2023 06:42 AM
There's a `CREATED_TIME()` function that you can use, and you can get more information from the formula field reference
May I know what issues you faced with using the "Created Time" field as well?
Jan 31, 2023 07:57 AM
And if there are a lot of formulas based off this date, it might be worth just adding the 'Created Time' Field and referencing that.
Jan 31, 2023 09:34 AM
Option 1: Use the CREATED_TIME() function in a formula field.
Option 2: Use the Created Time Field.
Jan 31, 2023 09:57 AM
Jan 31, 2023 10:07 AM
I need the date to be created only when I change the curtain field with a certain value.
Jan 31, 2023 10:28 PM
Ah, you'll need an automation for that.
1. Create a "Last Modified" field
2. Create a "Date" field called "Date changed" or anything you want
3. Create an automation that triggers when the field has that value, and its action will be to update the record by pasting the value in "Last Modifed" from Step 1 into the "Date" field from Step 2
Jan 31, 2023 10:33 PM
I think I found a solution. In the formula that I wrote, instead of writing the function NOW () I wrote the function DATE_MODIFYׁ() and it gave me the date automatically. I entered my Base today and saw that the date remained yesterday's date. Hope I didn't miss something 🙂