Date format

[Guest]

I know this is very simple but I am not able to figure it out. I would like
to convert a date that is stored in short date format to long date format
without the day of the week.
Example:

12/16/2005 => December 16, 2006.

I change the format on the text box that displays this value on the report
to long date but I am getting the day of the week. Any ideas how I can cut
off the day and just show the date as listed above.

Thanks for all your help.

Nats

 

[Guest]

mmm yyyy will give you a 3 letter month and the 4 digit year.

 

[fredg]

I know this is very simple but I am not able to figure it out. I would like
to convert a date that is stored in short date format to long date format
without the day of the week.
Example:

12/16/2005 => December 16, 2006.

I change the format on the text box that displays this value on the report
to long date but I am getting the day of the week. Any ideas how I can cut
off the day and just show the date as listed above.

Thanks for all your help.

Nats

Simply set the Format property of the control to:
mmmm d, yyyy

 

[Guest]

The format you are looking for is prob mmmm yyyy

If you press F1 while in the format box it will take you to a list of format
characters.

 

[Guest]

Thanks a bunch....

Simply set the Format property of the control to:
mmmm d, yyyy