Date() function on reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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]
 
Back
Top