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

[llheath (Laurie)]

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 (Chris)]

Hi,

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

C

[llheath (Laurie)]

DATE([TimeStamp])
worked thnaks