I use the date() function on a report to display the date in the medium time
format of 05-Oct-05. However on the report, I would like it to be displayed
without the dashes like 05 Oct 05. Is this possible? Also would it be
possible to format it so it displays 05 October 05 or 05 October 2005?

thanks
Dan

I don't think their are any formats that match that layout, but you can
make it yourself.

In the format property, use:

dd m yy OR dd mmmm yyyy

Strike Eagle wrote:
> I use the date() function on a report to display the date in the medium time
> format of 05-Oct-05. However on the report, I would like it to be displayed
> without the dashes like 05 Oct 05. Is this possible? Also would it be
> possible to format it so it displays 05 October 05 or 05 October 2005?
>
> thanks
> Dan

On Mon, 4 Sep 2006 22:35:01 -0700, Strike Eagle
<(E-Mail Removed)> wrote:

>I use the date() function on a report to display the date in the medium time
>format of 05-Oct-05. However on the report, I would like it to be displayed
>without the dashes like 05 Oct 05. Is this possible? Also would it be
>possible to format it so it displays 05 October 05 or 05 October 2005?
>
>thanks
>Dan

Sure. You can format dates using the builtin formats, *or* your own
custom formats. It takes some "drilling down" in the Help screen to
find it, but you have a whole bunch of formats you can combine.

These examples would be

dd mmm yy
dd mmmm yy
dd mmmm yyyy

respectively, and you can of course add punctuation or text as you
wish:

"'Day 'dd' of the month of 'mmmm', Anno Domini 'yyyy"

for example.

John W. Vinson[MVP]