Format Date!!!

I have the Date field in the report. How can I format that field to "dd-mmm-yy" (Ex: 01-12-05 will display 01-Dec-05 in the report)?

Where can I find the custom code pattern of field format?

Thks,

Hi,

try something like this

=Day(Today) & "-" & MonthName(Month(Today),true) & "-" & Year(Today)

if your format differs from any other standard date format.

if not use the FormatDateTime-Method. For documentation look here.

-Antilles-

|||

Use this: http://msdn2.microsoft.com/en-us/library/8kb3ddd4.aspx

or this: http://msdn2.microsoft.com/en-us/library/az4se3k1.aspx