Date format?

[bigfoot53]

Hey all,

HOw do i only display the MONTH, DATE in a form/table.
I just need the full month and date no year in caps .

any thoughts?

thanks Bruce

 

[R. Hicks]

Try:

UCase(Format([YourDateField],"mmmm"", ""dd"))

HTH
RDH

 

[bigfoot53]

Thanks ,
but where do i put it i have tried several things but notworking.

 

[Dave Eyley]

It would depend on you as the designer to where the code goes.

If you wanted to save the date in this format it would have to be formatted elsewhere e.g. from an afterupdate on the control.
You might want to have a visible control on the form where the user inputs the normal date and then the control applies the format and puts it in another control bound to the table.

It could go on the form's ONOpen property where it could fill an unbound visible property if it was today's date you were using. e.g.


Me!MyDate= UCase(Format([Date()],"mmmm"", ""dd"))


The options are almost endless....

Try experimenting with some of the above.
If you want to describe the actual way you intend to use the format, somebody will, no doubt, give you a more specific response.


HTH

Dave E

 

[bigfoot53]

help

I have a form that is linked to a table i need to display on the form the Month and day only and save it to the table .I have tried the code but just can't seem th get it in the right place to make it work.

thanks for all the help.

 

[Dave Eyley]

From what you say I would assume that you want the date field on the form to take the value from the user and save it in the new date format described. Yes?

Dave E

 

[Rich]

What reason would you have for wanting to "Store" the date using this format?