Truncate function???

Does anybody know if there is a similiar function in MS
Access like the ORACLE "TRUNCATE" function?

eg:

trunc(RSS_TRACKING.COMPLETION_DATE) AS COMPLETION_DATE

result is: 6/29/03

The truncate function basically will aggregate dates
(which I have in my GROUP BY clause) based off of a
common starting point, like every Sunday, for instance.

I tried using ROUND, but it seems only for numbers, not
dates. I also tried using the CONVERT and CAST functions
in addition to the ROUND function, but still couldn't do
the date conversion.

Thanks,

Bill.......

Merlin
Fri Jul 11 16:34:39 CDT 2003

I'm not familiar with Oracle and I'm not sure I understand your questions,
but in MS Access you can either create your own functions in code or use the
Format function:-
e.g replace the field name with an expression as in the following example;
this converts the date into Days (Monday - Sunday), which can then be
grouped in the normal manner. You can convert the date into any number of
different formats for sorting grouping.

Expr1: Format([RSS_TRACKING.COMPLETION_DATE],'dddd')

(use 'www' for week numbers or 'dddd www' for Day & week number) very useful
little function....

Merlin

"bill yeager" <wsyeager36@msn.com> wrote in message
news:007b01c3470f$252c5610$a401280a@phx.gbl...
> Does anybody know if there is a similiar function in MS
> Access like the ORACLE "TRUNCATE" function?
>
> eg:
>
> trunc(RSS_TRACKING.COMPLETION_DATE) AS COMPLETION_DATE
>
> result is: 6/29/03
>
> The truncate function basically will aggregate dates
> (which I have in my GROUP BY clause) based off of a
> common starting point, like every Sunday, for instance.
>
> I tried using ROUND, but it seems only for numbers, not
> dates. I also tried using the CONVERT and CAST functions
> in addition to the ROUND function, but still couldn't do
> the date conversion.
>
> Thanks,
>
> Bill.......