Skip to main content

If last updated date is today, enter X in field

  • October 10, 2023
  • 4 replies
  • 61 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!

 


 

 

This topic has been closed for replies.

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