Custom Date Format

[JPritch]

Not sure if this is a Tables or Forms problem, so please excuse me.

I am creating a database where users will be entering Survey data. The Survey dates are in the format: Month-Year (February 2005, December 2004) etc....

I would like to capture the dates in that format, but retain the functionality that comes with Date type fields. For example to query a date range.

How and where do I specify the Date Format I desire?

 

[ColinEssex]

Have the dates entered normally then use this

Format([YourDateField],"mmmm yyyy")

to display in your format on the form

Col

 

[JPritch]

You da Man!

Works like a charm!