Skip to main content
Solved

Static date function in IF()

N

Hi All, I am trying to get a function to enter the current date when I change the status to done but I want the date to stay static and I cant figure out what date function to use for this. Here is what I have:

IF(Status=“Done”, DATETIME_FORMAT(TODAY(),“DD/MM/YYYY”), BLANK())

Now when I changed one item to “Done” yesterday it put in yesterdays date but when I logged in today it had todays date instead. I figured this would happen but don’t know what to put where I have “TODAY()” to get this to work.

Can anyone help me with this?

Best answer by Databaser

HI @Nicola_Pilcher and welcome to the community!

As far as I know, you will have to use and automation for this.

New field: last modified > specified for your status field

Trigger: when a record matches conditions (status = done)
Action: update record (new date field = date in “last modified” field")

That way, you get a static date when you change the status to “to do”.

View original
Did this topic help you find an answer to your question?

4 replies

Databaser
Forum|alt.badge.img+19
  • Databaser
  • Inspiring
  • 866 replies
  • Answer
  • July 16, 2021

HI @Nicola_Pilcher and welcome to the community!

As far as I know, you will have to use and automation for this.

New field: last modified > specified for your status field

Trigger: when a record matches conditions (status = done)
Action: update record (new date field = date in “last modified” field")

That way, you get a static date when you change the status to “to do”.

Jan - Databaser
kuovonne
Forum|alt.badge.img+27
  • kuovonne
  • Brainy
  • 6002 replies
  • July 16, 2021
Databaser wrote:

HI @Nicola_Pilcher and welcome to the community!

As far as I know, you will have to use and automation for this.

New field: last modified > specified for your status field

Trigger: when a record matches conditions (status = done)
Action: update record (new date field = date in “last modified” field")

That way, you get a static date when you change the status to “to do”.


Why not have just the last modified time field without the automation? If you need the field to be blank when the status is not done, do that with a formula field that shows the last modified time only when the status is done.

ScottWorld
Justin_Barrett
F
5 people like this
  • ScottWorld
    ScottWorld
  • Justin_Barrett
    Justin_Barrett
  • F
    Furst_Name
  • Databaser
    Databaser
  • Kamille_Parks11
    Kamille_Parks11
N
  • Nicola_Pilcher
  • Author
  • New Participant
  • 2 replies
  • July 20, 2021
Databaser wrote:

HI @Nicola_Pilcher and welcome to the community!

As far as I know, you will have to use and automation for this.

New field: last modified > specified for your status field

Trigger: when a record matches conditions (status = done)
Action: update record (new date field = date in “last modified” field")

That way, you get a static date when you change the status to “to do”.


Thank you @Databaser I didn’t think to do that

Databaser
1 person likes this
  • Databaser
    Databaser
N
  • Nicola_Pilcher
  • Author
  • New Participant
  • 2 replies
  • July 20, 2021
kuovonne wrote:

Why not have just the last modified time field without the automation? If you need the field to be blank when the status is not done, do that with a formula field that shows the last modified time only when the status is done.


I add nots into certain items after they have been completed so a general last modified wouldn’t work here. But thanks anyway.

Reply


Most helpful members this week

Terms & Conditions