date time in a group by

[Ruslan Zasukhin]

on 3/12/03 8:54 PM, X Y at xyzabc1010 at yahoo.com wrote:

> 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?

What this format do ???

Well, in any case, if you want modify something, then you need create
BaseObject method (i.e. Calculated field)


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://listserv.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------