Skip to main content

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!

 


 

 

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"
)))

 

 

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"
)))

 

 


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?

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?


Try with this:

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

Try with this:

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

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

Reply


Terms & Conditions