Help

If last updated date is today, enter X in field

Topic Labels: Formulas
494 4
cancel
Showing results for 
Search instead for 
Did you mean: 
KP217
5 - Automation Enthusiast
5 - Automation Enthusiast

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."
 
KP217_5-1696965447514.png
Here is the way the formula field is set up 

 

KP217_4-1696962520401.png
Here is how the last-updated field is set up
KP217_0-1696961221705.pngKP217_1-1696961258117.png

Here is the way the start date field is set up 

KP217_3-1696962418615.png

 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!

 


 

 

4 Replies 4
lguerzon27
5 - Automation Enthusiast
5 - Automation Enthusiast

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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
5 - Automation Enthusiast
5 - Automation Enthusiast

Try with this:

IF(DATETIME_DIFF(LAST_MODIFIED_TIME(), TODAY(), 'days')=0, "string")
KP217
5 - Automation Enthusiast
5 - Automation Enthusiast

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