In a formula field, I am trying to subtract days from a date field. The formula field displays the correct date, but also includes the time. Is there a simple way to strip the Time and display only the date?
I know it can be done in a tedious way, by creating more formula fields, convert to string, then getPrefix, then convert back into a date, etc, but i was hoping there was a way to accomplish this all within the one Formula field.
- (Registration_Expiry.subDay(150))
the Original date field contains
27 Jul 2014
the result in the formula field shows
27 Feb 2014 03:00:00