Skip to main content

If last updated date is today, enter X in field

  • October 10, 2023
  • 4 replies
  • 34 views
K
Forum|alt.badge.img+4

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!

 


 

 

4 replies

lguerzon27
Forum|alt.badge.img+3
  • lguerzon27
  • New Participant
  • October 10, 2023

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

 

 

K
Forum|alt.badge.img+4
  • KP217
  • Author
  • Inspiring
  • October 11, 2023

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?

lguerzon27
Forum|alt.badge.img+3
  • lguerzon27
  • New Participant
  • October 13, 2023

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")
K
Forum|alt.badge.img+4
  • KP217
  • Author
  • Inspiring
  • October 16, 2023

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?

Terms & ConditionsAccessibility statement