Have a date/timestamp field want to group on date only

[llheath]

I want to capture the date and time but on my view I only want to group on date.If I create a virtual column for the date would would the expression be to get it out of my date/time field?

[Chris_Jeal · Accepted solution]

Hi,

Yes, using date([timestamp]) should extract the date from the timestamp.

C

[llheath]

DATE([TimeStamp])
worked thnaks