Date Modified - Copy of column creates different date

EPayne

Hello, 

I am working to create an automation off of the date modified field. This is to alert users if they have not updated a row in more than 4 days. Since the date modified field is not recognized as a date field I created a copy of the column using the basic formula: 

=[Last Modfied]1

My results are not what I would expect. Take a look at the screen shot. 10/31 is showing at 11/1 - From my testing I am guessing the cut off is any time after 4PM the date becomes a day later? Is there a way to update this to 12AM? or is this an bug that smartsheets can fix?  

Thanks for taking a look, 

EPayne

 

 

Jose da Silva

Hi,

 

If all that you want is to notify users of no updates after 4 days, why don't you just create an automation that does that, and save yourself the hassle of having another column?