Skip to main content

Hi there,


I just need a little help to finish my workflow !


I want to put a status from the automatic field “Last modified time”.


Formula is : IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 13, “ ❗ ”, IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 7, " ⏰ ", IF(DATETIME_DIFF({Update URL}, TODAY(),‘days’) >= 1, “ 🔁 ”, IF(IS_SAME(TODAY(), {Update URL}), “New 🚀 ”)))))


It works pretty fine when the field is “date” but won’t work when field is modified in “Last modified time”.


Anyone can help please ?

Can you include a screen shot of the three fields?

Can you include a screen shot of the three fields?



It looks like the formula field does not recognize that it is the current date. It is possible that there is a time zone issue going on. Depending on your time zone the displayed date might not match the day of TODAY().


Are you up for a little test?



  • create a new formula field that simply shows TODAY() and set it to show the time and use GMT time.

  • set your ‘Last modified time’ to also show the time and use GMT time as well.

  • Send a new screen capture of the results.

It looks like the formula field does not recognize that it is the current date. It is possible that there is a time zone issue going on. Depending on your time zone the displayed date might not match the day of TODAY().


Are you up for a little test?



  • create a new formula field that simply shows TODAY() and set it to show the time and use GMT time.

  • set your ‘Last modified time’ to also show the time and use GMT time as well.

  • Send a new screen capture of the results.


Thanks a lot for your reply !

Here’s a screenshot. As you can see, both fields are set DD/MM/YYYY… 😕


I’ve not used the IS_SAME() function much, but checking the docs, you’re missing a third element: the unit of comparison:



IS_SAME(Adate1], 1date2], 2unit])



Similar to how you have “days” as a unit of comparison for DATETIME_DIFF(), try adding “day” as the unit of comparison for IS_SAME(). By omitting that unit string, there’s no way of knowing how it’s trying to compare those two dates: hour? day? month? second?

I’ve not used the IS_SAME() function much, but checking the docs, you’re missing a third element: the unit of comparison:



IS_SAME(Adate1], 1date2], 2unit])



Similar to how you have “days” as a unit of comparison for DATETIME_DIFF(), try adding “day” as the unit of comparison for IS_SAME(). By omitting that unit string, there’s no way of knowing how it’s trying to compare those two dates: hour? day? month? second?


Yeeah thank you very much !!


Reply


Terms & Conditions