Extract Date from Modified Date


I am trying to use the Modified Date column in formulas. For some reason, it doesn't appear that this was created as a "Date" column type. Because of this, it cannot be used in any formulas that would allow a date. Is this assessment correct? Also, is there a way of pulling the date out? I've pulled out the Month, Day, and Year individually into three separate columns, but then when I concatenate them using "+'s", it still doesn't work because it is not a date format. Can somebody please tell me how to get the date out of this column?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!