Date format

N

Natalie

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
 
F

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

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

Datasort

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.
 
Top