If last updated date is today, enter X in field

[KP217]

Hello,

I have a formula field that is supposed to return a value ("updated") when a last-updated field is today.
I live in another time zone, but all of my dates are set to Eastern time to reflect my working hours. Some of the posts I have read have said that a time zone error will produce this problem. To show that all time fields are set up for Eastern, I am including screenshots below.

You can see that the last updated date/time is today (10/10), and the value of today is also 10/10.

The formula field is not showing the value "updated."

Here is the way the formula field is set up 

Here is how the last-updated field is set up

Here is the way the start date field is set up 

 I have also tried using "now" instead of "today."

I am sure that there is an explanation, but I'm unable to find one based upon my searches of the community posts.

Thank you for any help you can provide!

[lguerzon27]

Hello,
you could use a variety of date/time comparison formula functions. IE:

IF( IS_AFTER({due date}, {completion date}), "early",
IF( IS_BEFORE({due date}, {completion date}), "late", 
IF( IS_SAME({due date}, {completion date}), "on time"
)))

---

[KP217]

Thanks for the reply! This also did not work for me. Do you have any other solutions for taking a field's last updated date and getting a text value when that date is the same as today?

[lguerzon27]

Try with this:

IF(DATETIME_DIFF(LAST_MODIFIED_TIME(), TODAY(), 'days')=0, "string")

[KP217]

Thanks for this! I get "string" no matter what the last modified time is. Any suggestions?