Displaying date only from datetime

[feenyjamie]

Hello all!

I have an expense app where I take the datetime (now()) when the user adds the expense.  I do this so that the most recent expense is at the top of the list instead of alphabetical, when the expenses are sorted by date.

While I want the time for sorting, I do not want to display the time in the inline rows.  I was hoping I could just change the display format easily to keep the time but only show the date.

I tried various things before settling on creating a virtual column with this formula:

DATE(INDEX(SPLIT([Expense Date], " "), 1))

While it works during testing, it displays blank in the inline rows.

Any ideas?

[dbaum · Accepted solution]

Did you try:

DATE([Expense Date])

[feenyjamie]

Worked perfectly!  Thank you for your help @dbaum