I can’t seem to both calculate and format a date in the same cell. I add 55 years to a date of birth to come up with a 55th birthday (call this cell 55bday). That returns an ISO date that includes a time. I can, in another cell, use DATETIME_FORMAT and reference cell 55bday to remove the time. Can I do that all in one cell?
+20No need to use DATETIME_FORMAT() at all. Change the formatting of the field itself to remove the displayed time. In the field configuration popup, click the “Formatting” tab.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.