date time in a group by

[X Y]

Hi All,
I want to do the following
Suppose I have a table with a datetime field,
fldDateTime.

I want to group this field according to the date only
part --
It would be something like
SELECT id, Format(fldDateTime,"mm  dd yyyy"), 
SUM(foo)
FROM tableA
GROUP BY id, Format(TaskBeginDateTime,"mm  dd yyyy")

How would I go about this in Valentina?

Thanks

__________________________________________________
Do you Yahoo!?
Yahoo! Web Hosting - establish your business online
http://webhosting.yahoo.com