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?
Help Article Resources
Check out the Formula Handbook template!